Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SQL statement
where (Type = 'Int' and ID = '100') or ( Type IN ('SA,'TE') and ID = '200')
Qlik Script:
Load
IF((Wildmatch(Type,'Int') and match(ID,'100') )or (Wildmatch(Type,'SA,'TE') and match(ID,'200') ), 'Pack') as TestField
where i am doing wrong in Qlik if statement? Any help would be very much appreciated.
Thanks,
AH
Try this:
If((Type = 'Int' and ID = '100') or ( match(Type,'SA,'TE') and ID = '200'),'TRUE','FALSE') as TestField
Hope it helps!
Hi,
Maybe try with
load*,
pick(match(Type&ID,Int100,SA200,TE200),'Pack','Pack','Pack') as TestField
Try this:
If((Type = 'Int' and ID = '100') or ( match(Type,'SA,'TE') and ID = '200'),'TRUE','FALSE') as TestField
Hope it helps!