topic Re: Translating SQL where clause in Qlik If statement in QlikView

Translating SQL where clause in Qlik If statement

AH — Wed, 25 Nov 2020 16:16:04 GMT

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,

sergio0592 — Mon, 17 Feb 2020 21:55:09 GMT

Hi,

Maybe try with

load*, pick(match(Type&ID,Int100,SA200,TE200),'Pack','Pack','Pack') as TestField

TimvB — Mon, 17 Feb 2020 21:58:45 GMT

Try this:

If((Type = 'Int' and ID = '100') or ( match(Type,'SA,'TE') and ID = '200'),'TRUE','FALSE') as TestField

Hope it helps!