topic Put a count in a chart into a text box in QlikView

Put a count in a chart into a text box

mp802377 — Wed, 15 Mar 2023 15:38:59 GMT

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.

Re: Put a count in a chart into a text box

marcus_sommer — Wed, 15 Mar 2023 15:53:06 GMT

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

Re: Put a count in a chart into a text box

mp802377 — Wed, 15 Mar 2023 15:56:39 GMT

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