Handling DUAL #21
Description
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