Rank function not working for Subtotal in Pivot table

[#1]

Hi,

I have to do the ranking of the rows based on expression in Pivot table.

I have used the rank function as : Rank(Total (- Column(5))/Column(10))).

Using this expression, I am getting the ranking only for rows. For subtotal, it is not displaying anything.

Now, I have to do the ranking of subtotal also. Please help me, how I can achieve it.

[dinuwanbr]

Hi,

See the attach..

Can u upload ur sample?

BR,

Dinu1

[#3]

Hi,

I am not having the licence of QlikView, so unable to access it. Can you please provide the expression which you have written in the solution.

[Anonymous · Accepted solution]

why you are having - Column(5))??

try this:

=Rank(Total <Column(5)/Column(10)>,4)

[Anonymous]

or simply like:

=Rank(-L3/V3,4)  //where -L3/V3 is your expression name of 1st column