Dual - script and chart function

With the dual function it is possible to create arbitrary combinations of a number and a string.

Syntax:  

Dual( s , x )

 

Forced association of an arbitrary string representation s with a given number representation x.

In Qlik Sense, 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 40908 and the textual representation ‘2011-12-31’.

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.

Examples and results:

Example	Description
Dual('Q' & Ceil(Month(Date)/3), Ceil(Month(Date)/3)) as Quarter	This field definition will create a field Quarter with the textual values 'Q1' to 'Q4' and at the same time assign the numeric values 1 to 4.
Dual(WeekYear(Date) & '-W' & Week(Date), WeekStart(Date)) as YearWeek	This field definition will create a field YearWeek with textual values of the form '2012-W22' and at the same time assign a numeric value corresponding to the date number of the first day of the week, e.g. 41057.