topic Re: Top N Salary. in QlikView

Top N Salary.

Sun, 28 Jun 2015 15:56:10 GMT

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.

Siva_Sankar — Mon, 29 Jun 2015 10:19:36 GMT

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 — Mon, 29 Jun 2015 10:23:27 GMT

try tis,

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

if not pls share ur app.