topic Re: IF Condition in QlikView

IF Condition

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

How to write this is Qlikview Script:

if "&prod_name." NE "ELECTRONICS" then do;

if compress(UPCASE(LOB)) in ("DIRECT","PORTAL","OFFLINE") then BUSINESS = "DIRECT";

else if compress(UPCASE(LOB)) in ("VENDOR","ONLINE","THIRDPARTY","DEALER","INDIRECT") then BUSINESS = "INDIRECT";

else BUSINESS = "UNALLOCATED";

END;

Any help would be appreciated.

Thanks in Advance

Eric

Re: IF Condition

settu_periasamy — Wed, 25 May 2016 04:30:16 GMT

Hi Eric,

Not sure about the Compress function. May be look the below script code..

LOAD OtherFields,
if( not Match(Upper(prod_name),'ELECTRONICS'),
if( Match(Upper(LOB),'DIRECT','PORTAL','OFFLINE'),'DIRECT',
if(Match(Upper(LOB),'VENDOR','VENDOR','THIRDPARTY','DEALER','INDIRECT'),'INDIRECT',
'UNALLOCATED'))) as Field
From Source;

Re: IF Condition

sujeetsingh — Wed, 25 May 2016 04:34:14 GMT

if (prod_name=" NE "ELECTRONICS",

if compress(wildmatch(UPCASE(LOB)) 'DIRECT','PORTAL','OFFLINE')) ,'DIRECT',

if compress(wildmatch(UPCASE(LOB)'VENDOR','ONLINE','THIRDPARTY','DEALER','INDIRECT') )'INDIRECT'

,'UNALLOCATED'))) as Bussines

Re: IF Condition

ziadm — Wed, 25 May 2016 04:36:42 GMT

Try

Load

If (match (Upper(LOB) ,'DIRECT','PORTAL','OFFLINE') > 0,'DIRECT',If (match (Upper(LOB) ,'ONLINE','THIRDPARTY','DEALER','INDIRECT') >0, 'INDIRECT','UNALLOCATED') ) as FieldName