Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mp802377
Creator II
Creator II

Put a count in a chart into a text box

I have a table chart. It has a sum where the volume is greater than the Min Count using Set Analysis. The table (in Total Mode) counts the rows. You can see it counts to 3. I would like to have the 'Number of unique items selected' to be 3. Is there a way to do this? I want the text below (Number of unique items selected) to reflect a count of 3, and not 1.

 

Qlikview Questions.jpg

 

Labels (1)
1 Solution

Accepted Solutions
mp802377
Creator II
Creator II
Author

Thank you! That worked. I had tried aggr(count. I didn't realize I had it backwards. Thank you!

 

View solution in original post

2 Replies
marcus_sommer

Try it with: count(aggr(YourExpression, Item))

mp802377
Creator II
Creator II
Author

Thank you! That worked. I had tried aggr(count. I didn't realize I had it backwards. Thank you!