Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

harrytye
New 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
Highlighted
flipside
Valued Contributor II

Re: Showing people in group numbers

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

3 Replies
aarkay29
Valued Contributor

Re: Showing people in group numbers

PFA

Highlighted
flipside
Valued Contributor II

Re: Showing people in group numbers

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

harrytye
New Contributor II

Re: Showing people in group numbers

Thanks this worked great and was very accurate.