IF Statement

[AH]

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

[#2]

Hi,

Try something like

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

[its_anandrjs · Accepted solution]

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.

http://community.qlik.com/message/680775#680775

Regards

Anand

[AH]

Thanks Guys! I That helps.

Regards

Shan