what is dual function?

[gkcchowdary]

explain about dual function in script level with example

[Gysbert_Wassenaar]

See How to use- Dual()

And make sure you installed the help file when you installed Qlikview. You can open the help file from the Help menu in Qlikview Desktop

[kushalthakral]

Hi

Dual function is nothing but stores two values like in text and as well as in number

so if u take an example of dual(month, month_no)

Month     Month_No

Jan          1

Feb          2

Mar          3

then if u write exp like text(dual(month, month_no) it will give you Jan

and if u write like num(dual(month, month_no) it will give you 1

Regards

Kushal T