dual function()

[#1]

Hello Community,

I'm new to qlikview and may I've more knowledge on dual function() along with perfect example to easily understand.

Please help me in this in detail if anyone knows.

Regards,

Sattish

[maxgro]

Qlik Tips: Using Dual

[marcus_malinow]

Satish,

dual allows you to store a value as both text and a number.

For example,

dual('Yes', 1)

dual('No', 0)

This would enable you to sort by the numeric part which may be in a different order to the text order, or maybe sum it, whereas if it were a plain text field this might not be possible.

[#4]