Nested aggr??

belromvar — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Nested aggr??

tresB — Mon, 28 Aug 2017 11:13:53 GMT

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

Exp: Count( Distinct User)

Re: Nested aggr??

belromvar — Mon, 28 Aug 2017 11:23:07 GMT

Thanks Tresesco it works 😃

topic Nested aggr?? in QlikView

Nested aggr??

Re: Nested aggr??

Re: Nested aggr??