topic Re: Using of IF statement in QlikView

Using of IF statement

AH — Mon, 15 Dec 2014 18:23:29 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

Re: Using of IF statement

its_anandrjs — Mon, 15 Dec 2014 18:32:32 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'))

Regards

Anand

Re: Using of IF statement

MK_QSL — Mon, 15 Dec 2014 19:39:29 GMT

Little shorter version

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

Re: Using of IF statement

MarcoWedel — Mon, 15 Dec 2014 22:41:19 GMT

Hi,

one solution could be also:

mapCurrency:
Mapping LOAD * Inline [
Area, Currency
A,USD
B,GBP
C,GBP
D,GBP
E,GBP
];

table1:
LOAD *,
    ApplyMap('mapCurrency', Area) as Currency,
    Ceil(Rand()*100) as fact1,
    Ceil(Rand()*100) as fact2;
LOAD Chr(65+Floor(Rand()*5)) as Area
AutoGenerate 20;

hope this helps

regards

Marco