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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression with an and condition

Dear all,

I have a graph in which I would like to filter values based on two conditions, the statecode shoud be 0 and the statereason should be 2.

This works fine.

Count({$<STATECODE = {0}>}TEAM)

However when I add an and statement like this:

Count({$<STATECODE = {0}>} AND <STATEREASON= {2}>} TEAM)

I get an error (memory exceeded). Any thoughts where I go wrong>?

1 Reply
sunny_talwar

Try with a comma instead of and:

Count({$<STATECODE = {0}, STATEREASON= {2}>} TEAM)