topic Re: Dynamic Ranking in Listbox based on selection from Another Listbox in QlikView

Dynamic Ranking in Listbox based on selection from Another Listbox

Thu, 03 Jul 2014 15:02:31 GMT

HI All,

I am trying to get the below working. I have an employee table with Income and Productcount

In the Selection table, I just have the column names Income and Productcount as values for the field TYPE.

I have the employee names listed and sorted using an expression which uses rank function.

What I am trying to achieve is,

Based on the selection in the TYPE list box, the Dynamic list box should rank the employees.

Attached is the sample qvw. Any help is much appreciated.

Thanks

Re: Dynamic Ranking in Listbox based on selection from Another Listbox

MK_QSL — Thu, 03 Jul 2014 15:11:26 GMT

Under sorting tab expression, use below

=IF(GetFieldSelections(TYPE)='Income',Aggr(SUM(Income),emp),Aggr(SUM(Productcount),emp))

Re: Dynamic Ranking in Listbox based on selection from Another Listbox

Thu, 03 Jul 2014 15:46:04 GMT

Thank you. It worked. How will I make it to work if I choose both Productcount and Income (combined ranking)

Re: Dynamic Ranking in Listbox based on selection from Another Listbox

MK_QSL — Thu, 03 Jul 2014 15:51:59 GMT

If you want combine ranking, let me know which criteria you would like to use..

Re: Dynamic Ranking in Listbox based on selection from Another Listbox

Thu, 03 Jul 2014 15:57:47 GMT

I did slightly change the empression to use rank instead of sum like below,

IF(GetFieldSelections(TYPE)='Income',Aggr(rank(Income,4),emp),Aggr(rank(Productcount,4),emp))

The criteria is to again sort the employees usinng combined ranking. Does that make sense?

Re: Dynamic Ranking in Listbox based on selection from Another Listbox

Thu, 22 Jan 2015 17:11:31 GMT

Hi Manish,

I had to put a hold on this logic so getting back into the issue again. How should we do combined Ranking like in the Golf Game. But the trick is the Employee List box or the chart with the Employee and individual Ranks should be ranked for the selected values in the TYPE list box. I am thinking of or statement in the sort expression. But not sure.

Your help is much appreciated. Attaching the modified version of the qvw.

Thanks,