Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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.


EmployeeAreaFrequencyRank
A1601
B1591
C2581
C3581
D4571
E5561

Expected :

EmployeeAreaFrequencyRank
A1601
B1592
C2583
C3583
D4574
E5565

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

1 Reply
Highlighted

Try this

Aggr(Rank(TOTAL Sum(Frequency), 1,1), Employee, Area)