topic Re: Use multiple conditions in a where clause in QlikView

Use multiple conditions in a where clause

Wed, 28 Sep 2016 09:57:15 GMT

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 — Wed, 28 Sep 2016 09:58:11 GMT

Try this

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

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

qlikview979 — Wed, 28 Sep 2016 10:45:35 GMT

Hi May be this

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

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

Regards

Mahesh