topic Re: in qlikview i want take top 10 salaries how to wright ? in QlikView

in qlikview i want take top 10 salaries how to wright ?

Sun, 06 Apr 2014 09:02:45 GMT

i have employee table and their salaries i want take top 10 in qlikview not in sql

Re: in qlikview i want take top 10 salaries how to wright ?

arsal_90 — Sun, 06 Apr 2014 09:21:00 GMT

There are number of ways to find top n:

One Way:

Sum({<Employee = {"=rank(sum(salaries), 4)<= 10"}>} salaries)

Second Way:

make a variable vtopN

and in dimension limits you pas that variable with selection of Greatest value

Re: in qlikview i want take top 10 salaries how to wright ?

arsal_90 — Sun, 06 Apr 2014 09:21:27 GMT

If you have any issue then share me your qvw

Re: in qlikview i want take top 10 salaries how to wright ?

MK_QSL — Sun, 06 Apr 2014 10:35:07 GMT

Please check enclosed file showing different ways to get top 10 employee based on salary..

1) Using Calculated Dimension

2) Using Set Analysis in Expression

3) Using Dimension Limit

4) How to show TOP 10 Employees based on Salary in Text Box along with Name and Salary..

Hope this helps..

Re: in qlikview i want take top 10 salaries how to wright ?

Sun, 06 Apr 2014 10:42:47 GMT

pls give clear explination

in all ways like using above 1,2,3,4 how to right expressions

Re: in qlikview i want take top 10 salaries how to wright ?

arsal_90 — Sun, 06 Apr 2014 10:45:00 GMT

can u share your qvw

Re: in qlikview i want take top 10 salaries how to wright ?

its_anandrjs — Sun, 06 Apr 2014 10:48:04 GMT

You can view Top 10 by the chart properties also from chart properties -> Dimension Limit -> show largest select 10.

Re: in qlikview i want take top 10 salaries how to wright ?

its_anandrjs — Sun, 06 Apr 2014 10:51:31 GMT

There are many ways you can show Top 10

1. From load script you can find top 10

2. From SET analysis expression.

3. From any variables in expression by input box.

4. From chart properties Dimension limits.

4. In any Bar charts also.

Regards

Re: in qlikview i want take top 10 salaries how to wright ?

MK_QSL — Sun, 06 Apr 2014 10:54:58 GMT

Consider that you have below in your script...

Employee:

Load * Inline

[

Employee, Salary

A, 10000

B, 20000

C, 24000

D, 40000

E, 100000

F, 50000

G, 125000

H, 80000

I, 75000

J, 40000

K, 50000

L, 35000

M, 25000

N, 50000

O, 35000

P, 20000

];

===================================

1) Using Calculated Dimension

Dimension = Calculated Dimension

=IF(Aggr(Rank(SUM(Salary),4),Employee)<=10,Employee)

Tick Suppress When Value is NULL

Expression = SUM(Salary)

2) Using Set Analysis in Expression

Dimension = Employee

Expression = SUM({<Employee = {"=Rank(SUM(Salary),4)<=10"}>}Salary)

3) Using Dimension Limit

Dimension = Employee

Expression = SUM(Sales)

Dimension Limits

Select Show only Largest 10 Values

4) If you want to show in Text Box

=CONCAT(IF(Aggr(Rank(SUM(Salary),4),Employee)<=10,Aggr(Employee&CHR(9)&MONEY(SUM(Salary),'#,##0'),Employee)),', '&CHR(10),-Aggr(SUM(Salary),Employee))

5) Using Script

Employee:

Load * Inline

[

Employee, Salary

A, 10000

B, 20000

C, 24000

D, 40000

E, 100000

F, 50000

G, 125000

H, 80000

I, 75000

J, 40000

K, 50000

L, 35000

M, 25000

N, 50000

O, 35000

P, 20000

];

NoConcatenate

Temp:

Load Employee, SUM(Salary) as Salary Resident Employee Group By Employee;

NoConcatenate

Final:

First 10

Load Employee, Salary Resident Temp Order By Salary Desc;

Drop Tables Employee, Temp;

Hope this helps...

Re: in qlikview i want take top 10 salaries how to wright ?

arsal_90 — Sun, 06 Apr 2014 10:58:27 GMT

Please find the attached file

Re: in qlikview i want take top 10 salaries how to wright ?

Sun, 06 Apr 2014 10:59:46 GMT

thanks bro

Re: in qlikview i want take top 10 salaries how to wright ?

arsal_90 — Sun, 06 Apr 2014 11:15:13 GMT

Manoj if your problem is resolved then marked this post as Answered for further people help

Thanks & regards

Re: in qlikview i want take top 10 salaries how to wright ?

Sun, 06 Apr 2014 13:48:09 GMT

Hi Dear in Qlikview 11 there is an option with name of Dimension limits enable that and use top 10 salaries.

Re: in qlikview i want take top 10 salaries how to wright ?

nizamsha — Sun, 06 Apr 2014 13:55:55 GMT

rank(sum(Salaries))

use dimension limit largest 10

Re: in qlikview i want take top 10 salaries how to wright ?

Sun, 06 Apr 2014 14:01:21 GMT

Yes Dimension limit Largest 10

Re: in qlikview i want take top 10 salaries how to wright ?

kkkumar82 — Tue, 21 Jul 2015 06:44:08 GMT

Can we find out if a selected employee comes in first 10 based on salaries in a text box.

Assume we have a list box with employee names, and if we select a employee and if his salary comes in first 10 then the text box should show a message for eg, "<employee name > comes in top 10, <his position>

Thanks

Kiran Kumar

Re: in qlikview i want take top 10 salaries how to wright ?

MK_QSL — Tue, 21 Jul 2015 08:11:40 GMT

Hi Kiran,

Not a good idea to ask question in an old thread. Kindly open a new question with possible sample data.

Hi manojqlik

Can you please close this thread by selecting appropriate answer?

Re: in qlikview i want take top 10 salaries how to wright ?

Wed, 22 Mar 2017 07:17:06 GMT

Hi Manish,

what is the 4 in this why are we using 4 for below formula?

=IF(Aggr(Rank(SUM(Salary),4),Employee)<=10,Employee)

i am trying to use same formula to get top 15

Re: in qlikview i want take top 10 salaries how to wright ?

kkkumar82 — Wed, 22 Mar 2017 15:31:10 GMT

Hi Ajay,

it is something related to when the values are same for different employees for eg, what we should do ,

you can check the syntax in the help , it will give you more examples

Best create a new thread, pointing to this thread.