Handling DUAL

[thebruuu]

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