topic Re: IF Statement in QlikView

IF Statement

AH — Mon, 15 Dec 2014 18:31:02 GMT

Hi,

I have a requirement like this,

IF the Area is A then Currecny is USD and

IF the Area is others (B,C,D,E.......etc) then currency is GBP

How would i apply this IF statements in a Textbox?

Thanks,

Shan

Mon, 15 Dec 2014 18:36:21 GMT

Hi,

Try something like

=if(Area='A',USD,GBP);

its_anandrjs — Mon, 15 Dec 2014 18:40:48 GMT

Hi,

Try this in any list box or the Text object

Load

If( Match(Area,'A'),'USD',

If( Match(Area,'B','C','D','E'),'GBP')) as [Currency Select]

From Source;

In list box

If( Match(Area,'A'),'USD',

If( Match(Area,'B','C','D','E'),'GBP'))

Please open single thread for the same question here is another one.

Regards

Anand

AH — Mon, 15 Dec 2014 18:47:52 GMT

Thanks Guys! I That helps.

Regards

Shan