Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Rookie
Contributor
Contributor

Qliksense frontend scripting for rank

There is a column name hours which calculate no of hours employee has worked and a column event which tells event name the employee has participated.I have to calculate rank of a person who has maximum hours and who has participated in maximum events(count of event against his name).also if two person has same rank then display both name in KPI. I want this in frontend.

Labels (1)
1 Reply
LRuCelver
Partner - Creator III
Partner - Creator III

I would recommend doing such complicated calculations in the script if possible.

{<PersonID = {$(=Concat(Aggr(If(Rank(Sum(Hours), 1) = 1, PersonID), PersonID), ','))}>}
Concat(Aggr(If(Rank(Count(Hours), 1) = 1, Person), PersonID), ', ')