Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
harrytye
Contributor II
Contributor II

Showing people in group numbers

Hi there,

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.

Thanks!

Desired outcome:

peoplelists
23
22
11

using a similar table:

 

peoplelist
johnA
johnB
johnC
jillA
tedB
tedC
mikeC
jenA
jenB
jenC
1 Solution

Accepted Solutions
flipside
Specialist II
Specialist II

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))

flipside

View solution in original post

3 Replies
aarkay29
Specialist
Specialist

PFA

flipside
Specialist II
Specialist II

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))

flipside

View solution in original post

harrytye
Contributor II
Contributor II
Author

Thanks this worked great and was very accurate.