Use multiple conditions in a where clause

[#1]

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?

[Anil_Babu_Samineni]

Try this

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

OR

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

[qlikview979 · Accepted solution]

Hi May be this

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

or

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

Regards

Mahesh