Multiple if else on field load script qliksense

jasmeenkr · ‎2019-12-11

Hi All,

I have requirement to create custom field load script in qlik sense with conditions like

(if field like 'Power* ( if field1 is null , then field2+field3 else field 1 ))

how to achieve it

dplr-rn · ‎2019-12-11

the format is if(condition , then , else)

not compactly clear on the logic you need but hopefully below can give you a start

load field,field1,.................

if(wildmatch(field,'Power*')=1,

, if(isnull(field1),field2+field3 , field 1 )

, else_condition_to_like_power) as NewColumnName

you can either put in the simple load statement or as a preceding load

jasmeenkr · ‎2019-12-11

The logic is like

If(Field like 'Power' and field1 is null then PM+field3)

else if(Field like 'File' and field1 is null then field2+field3

else if (Field like 'Sys' then field2+field3)

how to achieve this in Qlik sense load script

dplr-rn · ‎2019-12-11

something like below

If(wildmatch(field,'Power*')=1 and isnull(field1) , PM+field3,

if(wildmatch(field,'file*')=1 and isnull(field1), field2+field3,

if (wildmatch(field,'Sys*')=1, field2+field3)))

dplr-rn · ‎2019-12-12

mark as answered if the answers helped