Dual() combines a number and a string into a single record, such that the number representation of the record can be used for sorting and calculation purposes, while the string value can be used for display purposes
Return data type: dual
||The string value to be used in combination with the number argument.|
||The number to be used in combination with the string in the string argument.|
In QlikView, all field values are potentially dual values. This means that the field values can have both a numeric value and a textual value. An example is a date that could have a numeric value of
When several data items read into one field have different string representations but the same valid number representation, they will all share the first string representation encountered.
Add the following examples to your script and run it.
Load dual ( NameDay,NumDay ) as DayOfWeek inline
|Load Dual('Q' & Ceil(Month(Now())/3), Ceil(Month(Now())/3)) as Quarter AutoGenerate 1;||This example finds the current quarter. It is displayed as
||As in the previous example, the field
||This example create sa field