How to identify Top and Bottom Performer in Qlikview?

qlikview

#1

Hi,

I have created a daily score card in Qlikview. I received a additional requirement by the client that they want to display the name of top/ bottom five performers for day. It looks a decent requirement to drive the sales. I have tried to use aggr and rank function to perform this but no luck. Can you help me to perform this?

Regards,
Steve


#2

Steve,

We can use AGGR() function to visualize top and bottom performers. AGGR is used with Rank and concatenate functions. You can refer below link to look at the detail solution of similar situation.

Regards,
Sunil