Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
Partner - Master

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

View solution in original post

5 Replies
BrunPierre
Partner - Master
Partner - Master

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
Partner - Master

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!