topic Re: Nested if ? in QlikView

Nested if ?

Sat, 14 Jun 2014 13:48:17 GMT

Hi All,

I am in need to use nested if conditon in my application..

please share the nested if application ..

Regards,

Helen

maxgro — Sat, 14 Jun 2014 13:58:33 GMT

if('z'='a', 1,

if('z'='b', 2,

if('z'='c', 3,

'z not found'

)))

MK_QSL — Sat, 14 Jun 2014 15:44:03 GMT

You can use something like below

If(Customer = 'A', 'Germany',

If(Customer = 'B', 'Spain',

If(Customer = 'C', 'France',

'UK')))

Any customer outside name 'A', 'B' or 'C' will be allocated country as UK......