Nested aggr??

[belromvar]

Hi everyone,

I am new in Qlikview and I am trying to achieve the following: create a report that shows the number of areas visited by x number of uses.

My data looks like this:

User	Area
U1	B1
U1	B2
U2	B2
U2	B2
U2	B2
U3	B3
U4	B1
U4	B2
U4	B3

So far I just had success by applying  the following function Aggr(count(DISTINCT Area),User) to group my data by user and # of areas visited. Result:

User  NumberOfAreasVisited

U1          2

U2          1

U3          1

U4          3

My goal is to display a pie chart showing the number of areas visited by the users, something like: 2 users visited 1 area, 1 user visited 2 areas and 1 user visited 3 areas:

#areasvisited   #users

1                         2

2                         1

3                         1

any ideas/suggestions on how can I achieve that?

[tresesco · Accepted solution]

Calculated Dimension: Aggr(count(DISTINCT Area),User)

Exp: Count( Distinct User)

[belromvar]

Thanks Tresesco it works 😃