topic Re: IF CONDITION in QlikView

IF CONDITION

upaliwije — Sun, 14 Aug 2016 03:08:22 GMT

Hi Freinds

I have following condition in my data load script.But I do not get the expected results . There so many C_TYPES but all of them except defined below do not catagarise ito OTHERS catagory but shown seperately. Pls see whether condition is wrong if so correct me.

IF(C_TYPE='ST36','TOTAL_LOSS',IF(C_TYPE='ST06' OR C_TYPE='ST07' OR C_TYPE='ST08','LEGAL','OTHERS')) AS SET_CODE,

Re: IF CONDITION

johnca — Sun, 14 Aug 2016 03:54:52 GMT

Hi Upali, this should give the results you seek...

IF(C_TYPE='ST36','TOTAL_LOSS',

IF(C_TYPE='ST06','LEGAL',

IF(C_TYPE='ST08','LEGAL',

'OTHERS'))) AS SET_CODE

Re: IF CONDITION

upaliwije — Sun, 14 Aug 2016 04:24:39 GMT

THANKS