Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
suhas_chandran
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
sunny_talwar

Try this

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