Top 10 Salary in an Organization

[#1]

Hi,

i have a table with salary.i need to show top 10 salary in graph but there is no dimension limits . in qliksense

could u please tell me steps. one more doubt i need to show yearly treand  but there is no option in qliksense i tried with combit o chart also.

** bar chart with line chart , like above bar line chart should come**,monthly bar  and department wise line chart.

[#2]

IN Limitations there is options top amd bottom

[Anonymous]

Try this expression for salary (and same set analysis for each expression if there are multiple):

sum({<EmployeeID={"=aggr(rank(sum(Salary))<=10,EmployeeID)"}>} Salary)

[jagan · Accepted solution]

HI,

You can try Rank() and Aggr() for this

=Sum({<EmployeeID={"=Aggr(Rank(Sum(Salary)) <= 5, EmployeeID)"}>} Salary)

OR

=Aggr(If(Rank(Sum(Salary)) <= 5, Sum(Salary)), EmployeeID)

Hope this helps you.

Regards,

Jagan.

[Michael_Tarallo]

Hello abc / Satish, I have noticed you have posted many questions in the forums and that many have responded to you. When you get a chance can you also please update the ones where people have kindly responded to you as well as mark those correct or helpful so our team and community know that you have been helped.

You can see your activity by clicking on your name and then the activity tab:

satish.jb

Thanks for your help in improving how we can all work together in the Qlik Community.

Regards,

Mike T

Qlik

[#6]

Thanks Qlik Community,Michael For Your Quick Response Regarding My Doubts.i updated all my post