topic Re: Total Rank in QlikView

Total Rank

Mon, 26 Oct 2015 11:03:15 GMT

Hi All,

can any one help me on the below issue,

I have a Pivot table with Rank and Sales% for Type and Branch, Now I want one extra row that displays sum of the rank and rank of the sum of the rank[consider lowest value of rank sum as highest rank. ]

ex: For the first column Branch1 the sum of the rank is 20, For the Branch 2 sum of the rank is 10 ....., Now I want the rank for these values, the value which is having lowest sum value has better rank.

PFA.

Regards

John

Re: Total Rank

marcus_sommer — Mon, 26 Oct 2015 11:10:44 GMT

You could use an aggr() function for your Total's like:

if(dimensionality() = 0, sum(aggr(rank(YourExpression), Type)), rank(YourExpression))

- Marcus

Re: Total Rank

Mon, 26 Oct 2015 11:22:14 GMT

Thanks Marcus, I have tried your Expression but No luck.

Regards

John

Re: Total Rank

marcus_sommer — Mon, 26 Oct 2015 11:28:56 GMT

How looked the result from this expression, why it's wrong?

Re: Total Rank

swuehl — Mon, 26 Oct 2015 11:45:13 GMT

You already use a total calculation and it seems like you want to add the total rank to your new sum-of-rank (why so?).

It would be more feasible to achieve what you want when the total line can be used for your new calculation.

edit:

Attached a sample for a sum of rank and the rank of it, using the total line for the calculation and omitting the total from the sum.

Re: Total Rank

Mon, 26 Oct 2015 12:09:38 GMT

Hi Swuehl , whatever you said is correct however I can't do like you provided, it has to so the total line first and then add all the rank column values including with Total value then need to give horizontal rank for those sum values.

Regards

John