Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lakwinder
Contributor III

How do i do two where clauses in the load script?

Hi Guys,

How do i do a double where clause? what am i doing wrong in the following code?  Thank you in advance.

FROM Warehouse.dbo."XXXXXX"

WHERE PRODUCT IN ('XXX','YYY','ZZZ')

and

WHERE MONTH IN ('XXX','YYYYY','ZZZZZ')

;------------------------------------------------------------------------------------- ALSO TRIED OR

FROM Warehouse.dbo."XXXXXX"

WHERE PRODUCT IN ('XXX','YYY','ZZZ')

or

WHERE MONTH IN ('XXX','YYYYY','ZZZZZ')

1 Solution

Accepted Solutions
balrajahlawat
Esteemed Contributor

Re: How do i do two where clauses in the load script?

try this:

FROM Warehouse.dbo."XXXXXX"

WHERE PRODUCT IN ('XXX','YYY','ZZZ') or/and MONTH IN ('XXX','YYYYY','ZZZZZ')

//No need to repeat where clause again and again

3 Replies
balrajahlawat
Esteemed Contributor

Re: How do i do two where clauses in the load script?

try this:

FROM Warehouse.dbo."XXXXXX"

WHERE PRODUCT IN ('XXX','YYY','ZZZ') or/and MONTH IN ('XXX','YYYYY','ZZZZZ')

//No need to repeat where clause again and again

lakwinder
Contributor III

Re: How do i do two where clauses in the load script?

Cheers that worked, i won't forget the double where in a rush now.  Thanks

balrajahlawat
Esteemed Contributor

Re: How do i do two where clauses in the load script?

Cross checking is always importatnt

Community Browser