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
