Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use multiple conditions in a where clause

Dear all,

I would to like show values in a graph based on several conditions. The month should be "aug" and the year should be "2015:)

This works fine:

=count({$<MAAND = {"aug"} >} DATUM_CREATIE)

However when I want to expand it with another condition like this:

=count({$<MAAND = {"aug"} and YEAR ={2015} >} DATUM_CREATIE)

It doesn't work. Any thoughts on what goes wrong here?


1 Solution

Accepted Solutions
qlikview979
Specialist
Specialist

Hi May be this

count({<MAAND ={'aug'},YEAR ={2015}>}DATUM_CREATIE)

or

count(if(MAAND ='aug' and YEAR =2016,DATUM_CREATIE))

Regards

Mahesh

View solution in original post

2 Replies
Anil_Babu_Samineni

Try this

=count({$<MAAND = {"aug"}, YEAR ={'2015'} >} DATUM_CREATIE)

OR

=count({$<MAAND = {"aug"}, YEAR ={2015} >} DATUM_CREATIE)


Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
qlikview979
Specialist
Specialist

Hi May be this

count({<MAAND ={'aug'},YEAR ={2015}>}DATUM_CREATIE)

or

count(if(MAAND ='aug' and YEAR =2016,DATUM_CREATIE))

Regards

Mahesh