topic Re: How to create a column using multiple if condition in QlikView

How to create a column using multiple if condition

Anonymous — Mon, 18 Dec 2017 17:40:02 GMT

Hi All,

How to create a column(G) using multiple if condition .

Condition: S='a' and P<=3,'Y' or else 'N'

S='b' and P<= 5, 'N' or else 'O'

Source data:

S	P
a	2
a	2
b	3
b	5

Required output:

S	P	G
a	1	Y
a	4	N
b	6	O
b	5	N

Thanks,

Krishna

Re: How to create a column using multiple if condition

sunny_talwar — Mon, 18 Dec 2017 17:44:35 GMT

How is Column P changing? For the column G, try this

If(S = 'a',

If(P <= 3, 'Y', 'N'),

If(S = 'b',

If(P <= 5, 'Y', 'O'))) as G

Re: How to create a column using multiple if condition

darrell_tobin — Mon, 18 Dec 2017 18:08:40 GMT

Hi Try this:

=if(

S= 'a' and P<= '3' , 'Y',

If(S= 'a' and P> '3', 'N',

If(S= 'b' and P<= '5', 'N',

'0'

)))

Please like or mark if correct 🙂

Re: How to create a column using multiple if condition

MarcoWedel — Mon, 18 Dec 2017 21:44:36 GMT

Hi,

one solution could be also:

table1:
LOAD *,
    Pick(Match(S,'a','b'),
          If(P<=3,'Y','N'),
          If(P<=5,'N','O')) as G;
LOAD Pick(Ceil(Rand()*2),'a','b') as S,
    Ceil(Rand()*8) as P
AutoGenerate 10;

hope this helps

regards

Marco