Keep the same Rank after selection

regowins — Mon, 11 Feb 2013 20:13:13 GMT

Hi, I am using a calculated dimension to give me the Rank of payers. I want to know how to keep the payers rank even when I select only one payer. For example, in the chart I have 5 payers, of which payer X is currently ranked 4 and payer Z is ranked 2. If I select only Payer X his rank changes to 1. I would like his rank to show 4 even though I only have one payer selected.

I am using the following calculated dimension.

aggr(rank(total sum([Care Amt]),4,1),[Payer Name])

Thanks!

Re: Keep the same Rank after selection

swuehl — Mon, 11 Feb 2013 21:16:47 GMT

Try a set analysis set identifier 1:

aggr(rank(total sum({1} [Care Amt]),4,1),[Payer Name])

Re: Keep the same Rank after selection

regowins — Mon, 11 Feb 2013 21:56:39 GMT

Yes, Thanks again!!!

topic Keep the same Rank after selection in QlikView

Keep the same Rank after selection

Re: Keep the same Rank after selection

Re: Keep the same Rank after selection