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

Set Analysis - AND condition

Hi,

Please help me to get the count of Id's which have the records in Either 'On Hold' column OR 'Cancelled' Column...

I wrote the expression as below, but it is giving me only the data based on AND condition

Count({$<Month={'31/01/2013'},[On Hold]={1},[Cancelled]={1}>}[ID])

Please suggest me...

3 Replies
Not applicable
Author

Hi,

Please can you attach your sample application ?

Sokkorn
Master
Master

Hi,

Try this Count({<[On Hold]={1}>+<[Cancelled]={1}>} [ID])

Regards,

Sokkorn

Not applicable
Author

Try this:

Count({$<Month={'31/01/2013'},[ID]={'On Hold','Cancelled'}>}[ID])