topic Re: Top values in QlikView

Top values

soha1902 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have data like:

Now I want to display Top Employee name based on Salary. I need to display 5 text Boxes and In first text Box Higest Paid employee name, in second box 2higest salary paid employee name and so on.

Please suggest How should I get Top2, Top3 employee name based on there salary.

Re: Top values

Chanty4u — Mon, 22 Aug 2016 05:51:48 GMT

try

FirstSortedValue(EmpName,-Sal)

Max(Sal)

Max(Sal,1)

Max(Sal,2)

Re: Top values

jsingh71 — Mon, 22 Aug 2016 05:56:31 GMT

For First Text Box you should write:

=if(aggr(rank(Sum(Sal)),EmpName)=1,EmpName)

for 2nd

=if(aggr(rank(Sum(Sal)),EmpName)=2,EmpName)

and so on.....

Re: Top values

tamilarasu — Mon, 22 Aug 2016 06:33:59 GMT

Hi Soha,

Try this,

=Concat( Distinct IF(Aggr(Rank(Sum(Sal),0,1),EmpName)=1,EmpName),',')

=Concat( Distinct IF(Aggr(Rank(Sum(Sal),0,1),EmpName)=2,EmpName),',')

=Concat( Distinct IF(Aggr(Rank(Sum(Sal),0,1),EmpName)=3,EmpName),',')

The above expression works even If two or more employes have same salries.

Re: Top values

Anonymous — Mon, 22 Aug 2016 06:45:45 GMT

Hi Soha ,

Try the below expressions ,

=FirstSortedValue(EmpName,-Sal)

=FirstSortedValue(EmpName,-Sal,2)

=FirstSortedValue(EmpName,-Sal,3)

=FirstSortedValue(EmpName,-Sal,4)

=FirstSortedValue(EmpName,-Sal,5)

Re: Top values

beck_bakytbek — Mon, 22 Aug 2016 08:02:48 GMT

Hi Soha,

you can use the Chart, and use as Dimension:EmpName and as Expression: Salary,

and if you want to Show (for instance) 5 Top Employ, you can use a calculated Dimension:

if (aggr(rank(sum(Salary)), EmpName) <=5, EmpName, Null()) and Forget to check: Supress When Value is Null,

i hope that helps

beck

Re: Top values

antoniotiman — Mon, 22 Aug 2016 09:42:06 GMT

Hi,

in Text Box 1

=FirstSortedValue(DISTINCT EmpName,-Aggr(Sum(Sal),EmpName),1)

in Text Box 2

=FirstSortedValue(DISTINCT EmpName,-Aggr(Sum(Sal),EmpName),2)

and so on

Regards,

Antonio