Discussion Board for collaboration related to QlikView App Development.
I need some assistance with how to show the amount of people in lists.
For example I want to display the number of people who belong to multiple lists.
The goal would be to see the people who are highly engaged in the product and belong to multiple lists.
I wasn't sure if this was a Aggr function or creating a summary table in the load.
using a similar table:
It might be possible to do this in a straight table.
Create a calculated dimension: =aggr(count (distinct list), people)
Create an expression: =count(aggr(count(distinct list),people))
View solution in original post
Thanks this worked great and was very accurate.