topic Qliksense frontend scripting for rank in App Development

Qliksense frontend scripting for rank

Rookie — Mon, 26 Feb 2024 07:03:29 GMT

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.

Re: Qliksense frontend scripting for rank

LRuCelver — Mon, 26 Feb 2024 10:09:34 GMT

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), ', ')