Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Top 10 Salary in an Organization

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.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Top 10 Salary in an Organization

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.

5 Replies
Not applicable

Re: Top 10 Salary in an Organization

IN Limitations there is options top amd bottom

mov
Esteemed Contributor III

Re: Top 10 Salary in an Organization

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)

MVP
MVP

Re: Top 10 Salary in an Organization

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.

Employee
Employee

Re: Top 10 Salary in an Organization

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

Not applicable

Re: Top 10 Salary in an Organization

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