topic Syntax for Multiple Where Clauses in QlikView

Syntax for Multiple Where Clauses

Mon, 03 Nov 2014 17:21:22 GMT

I want to use two where clauses for the same table:

from...

Where Year("Oppo_Opened")>=2010

Where Field("Oppo_Type") = Record(Sales);

What is the correct syntax for this?

MarcoWedel — Mon, 03 Nov 2014 17:22:45 GMT

Where Year("Oppo_Opened")>=2010 AND Field("Oppo_Type") = Record(Sales);

MK_QSL — Mon, 03 Nov 2014 17:27:07 GMT

Use only one Where and And between two conditions...

Something like

Where Customer = 'A' And Country = 'B'

MarcoWedel — Mon, 03 Nov 2014 17:27:15 GMT

Are you talking about SQL selects, because your where clause does not seem to be QV script load syntax?

Mon, 03 Nov 2014 17:41:00 GMT

Thanks guys!

Definitely on the right track, but my syntax is still off.

For the second one -- how do i do -- WHERE (Fieldname) contains RecordName.

I have several opportunity types, but I only want to load those that have 'Sales' in Oppo_Type field.

MarcoWedel — Mon, 03 Nov 2014 17:43:02 GMT

Where Oppo_Type = 'Sales';