topic Ranking in the script in QlikView

Ranking in the script

Thu, 27 Mar 2014 14:04:06 GMT

Hi Everyone-

I am trying to create scenario in the script that ranks the top 10 departments (DEPT) based on overtime hours worked (OT HOURS). I'd like to create a variable for each department, 1 through 10. My goal is to take these variables and use them in my set analysis to say, for example ..... < DEPT = { 'Rank3' } > } .....

Any suggestions?

Thanks!

Mike

Re: Ranking in the script

MK_QSL — Thu, 27 Mar 2014 14:46:12 GMT

Can you provide sample data?

Simple script to get TOP in script can be done as below....

Temp:

Load * Inline

[

Customer, Sales,

A, 100

B, 80

C, 30

D, 300

E, 140

F, 60

A, 40

C, 80

D, 20

E, 30

];

NoConcatenate

Temp2:

Load Customer, SUM(Sales) as [Total Sales]

Resident Temp

Group By Customer;

Drop Table Temp;

NoConcatenate

Final:

FIRST 3

Load * Resident Temp2;

Drop Table Temp2;

Re: Ranking in the script

Thu, 27 Mar 2014 15:32:38 GMT

I have two tables that I am using for the chart... Table 1 contains DEPT and EmployeeID. Table 2 contains EmployeeID and OTHOURS. To get the total OTHOURS, I am calculating (in the dashboard) the SUM(OTHOURS) for each Employee. So, using teh suggested script will not work.

I'd like to rank the top 10 DEPT's by OTHOURS worked. Again, ranking them into a variable in the script to call on that variable in my set analysis. Just not sure how to do it.

Re: Ranking in the script

MK_QSL — Thu, 27 Mar 2014 15:36:33 GMT

Can you provide sample data?

Re: Re: Ranking in the script

Thu, 27 Mar 2014 15:48:10 GMT

Here is a sample