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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
louise119
Creator III
Creator III

Set analysis (count)

I want to count using set analysis.
I wrote the following, but I can't get the value.

what could be wrong?

Count({<Region_ID = 3 >} Sales)

1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

Count({<Region_ID ={3} >} Sales)

View solution in original post

5 Replies
BrunPierre
Partner - Master II
Partner - Master II

Count({<Region_ID ={3} >} Sales)

louise119
Creator III
Creator III
Author

I tried that, but it doesn't work...

I wanna calculate like
If (Region_ID = 3 , count (Region_ID))


Count({<Region_ID ={3} >} Region_ID)

BrunPierre
Partner - Master II
Partner - Master II

The expression is technically correct.

Post some data and your output.

louise119
Creator III
Creator III
Author

I tried below, it works.

=count(if(Region_ID=3, Region_ID))

louise119
Creator III
Creator III
Author

Thank you very much for your help!