topic Re: Confusing with DUAL function in QlikView

Confusing with DUAL function

veerendrakatika — Wed, 25 Nov 2020 16:16:04 GMT

anybody could post on elaborating about DUAL function. I believe that it is some thing like Interpretation.if we have an example along with explanation please post it on this thread.

Thanks

Veerendra

Re: Confusing with DUAL function

hector_munoz — Wed, 08 Mar 2017 07:51:13 GMT

Hi Vereendra,

Look at this: How to use- Dual()

Regards,

Re: Confusing with DUAL function

sasiparupudi1 — Wed, 08 Mar 2017 08:16:51 GMT

It basically gives you an ability to have a meaningful display value.

For example if you have a flag in the data that has 1 or 0, the users might want to see a string value "Yes/No" so you could use DUAL to do this for you

In the below ex, PaidFlag will display string value in the UI and to get to the numeric value, use Num(PaidFlag)

Ex:

Test:

Load

Name,

Amount,

Dual(if(Paid=0,'No','Yes'),Paid) as PaidFlag;

Load * Inline

[

Name,Amount,Paid

Victor,1000,0

Kenny,300,1

Daren,200,0

];

hth

Sas