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

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)