Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax for Multiple Where Clauses

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?

1 Solution

Accepted Solutions
MarcoWedel

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

View solution in original post

5 Replies
MarcoWedel

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

MK_QSL
MVP
MVP

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

Something like

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

MarcoWedel

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

Not applicable
Author

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

Where Oppo_Type = 'Sales';