SBentley / qvd-utils

Read Qlik Sense .qvd files
https://pypi.org/project/qvd/
Apache License 2.0
49 stars 18 forks source link

Handling DUAL #21

Open thebruuu opened 1 year ago

thebruuu commented 1 year ago

Most of the fields in Qlikview and ALL the fields in QlikSense are of type DUAL Dual is like an array/struct where first part is string and second is number

For example the command Now() in qlik generates a dual where the 1st part is a string in the default format specified in the qlik script , for example, '24/02/2023 20:32:43', and the second is the corresponding number 44981,856053241

DUAL fields can be generated manualy too : for example with DUAL('whatever',23). I did a test: I created a QVD with just a field and a row containing DUAL ... and unfortunately I got just the text part