Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Calculated Dimension: Aggr(count(DISTINCT Area),User)
Exp: Count( Distinct User)
Calculated Dimension: Aggr(count(DISTINCT Area),User)
Exp: Count( Distinct User)
Thanks Tresesco it works 😃