Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Top N Salary.

Hi,

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

could u please tell me steps. one more doubt i need to show ye arly 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 Replies
Siva_Sankar
Master II
Master II

Dimension limitis available from version 11. If you are not using qv 11 then you have to use calculated dimension like below.

=Aggr(If(Rank(Sum(SALARY), 1, 0) <= 5, EMPLOYEE), EMPLOYEE)

Find the attached example

buzzy996
Master II
Master II

try tis,

=Sum(Aggr(if(Rank(Sale)<=10,Sale),Country))

if not pls share ur app.