Top Performer

[sunil-kumar5]

Hi All,

I have total score column from Table A and EMP name from TableB and both are linked based on employee ID.

I wanted to have a KPI showing top performer with score like 'Sunil Kumar 90' so I tried below expression and its working fine.

=FirstSortedValue(EMP_NAME &' ' &Aggr(Sum(PMS.Total_Score), EMP_NAME), -Aggr(Sum(PMS.Total_Score), EMP_NAME))

Now its showing total score as 'Sunil Kumar 1000' however If I select last month it should give 'Sunil Kumar 90'.

I have year and month from same Table A, I have just picked Employee Name from Table B.

Please advise as how my KPI will refelect correctly based on month selection.

Thanks

[Brett_Bleess]

@sunil-kumar5 have a look at the following Design Blog post, hopefully that may shed some further light upon things, but I think you are missing something in the AGGR piece here is my hunch, but I am not very good with Set Analysis, so hopefully the post will get you what you need:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett