
Anonymous
Not applicable
2018-10-11
09:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
AGGR and Rank over Multiple dimension
Hi Qlikies,
I am facing a situation here where i have to calculate the RANK of the column FREQUENCY Based on 2 Dimension; Employee and Area. I have used the Below Expression as of now :
Aggr(Rank(Sum(Frequency)1,1),Employee,Area) and i am getting the below output. As per my understanding this is because it re-iterates the Ranking function for a new combination of Employee + Area. Not sure if am right.
Employee | Area | Frequency | Rank |
---|---|---|---|
A | 1 | 60 | 1 |
B | 1 | 59 | 1 |
C | 2 | 58 | 1 |
C | 3 | 58 | 1 |
D | 4 | 57 | 1 |
E | 5 | 56 | 1 |
Expected :
Employee | Area | Frequency | Rank |
---|---|---|---|
A | 1 | 60 | 1 |
B | 1 | 59 | 2 |
C | 2 | 58 | 3 |
C | 3 | 58 | 3 |
D | 4 | 57 | 4 |
E | 5 | 56 | 5 |
can someone help me understand how i can CONCAT the Employee and Area for the rank function to consider as one single column and assign the ranking or if there is any other way i could go about it. Thanks in Advance
Suhas Chandran
2,302 Views
1 Reply

MVP
2018-10-11
09:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
Aggr(Rank(TOTAL Sum(Frequency), 1,1), Employee, Area)
