topic Re: Re: Ranking Question in QlikView

Ranking Question

Anonymous — Mon, 11 Aug 2014 16:08:54 GMT

I am using the following expression to create a ranking of individual employee goals in the organization:

=AGGR(RANK(COUNT({1<OPENDATE={'>=$(vSelectedMinDate)<=$(vSelectedMaxDate)'}>}ACCTNBR)/(GOAL * GetSelectedCount(WEEK))),EMPLOYEE)

When I click on a department, I would expect the rankings to stay the same for all the individuals but be filtered for that department. What is happening is that the ranking changes to ranking within the department. Looking at other discussions on the web, I thought the "1" at the beginning of the set analysis statement would keep the rankings unchanged as you applied filters to the data.

Is there something I missed here? Is there a different syntax that I need to use to keep the overall ranking the same when applying filters to the data?

Thanks for the help.

Ed Torasso

Re: Ranking Question

MK_QSL — Mon, 11 Aug 2014 16:48:23 GMT

You can use TOTAL Qualifier... Better if you can upload some sample data or sample apps to work...

Re: Re: Ranking Question

Anonymous — Mon, 11 Aug 2014 17:16:38 GMT

Manish,

I'm not sure what you mean by use TOTAL Qualifier.

Attached is a file with sample data. As you can see in the application, if you select someone that is down on the ranking list, the ranking changes to show that individual as # 1 instead of their ranking in the overall organization.

I need to preserve the overall ranking when applying a filter to the data.

Thanks again for the help.