topic Rank function not working for Subtotal in Pivot table in QlikView

Rank function not working for Subtotal in Pivot table

Tue, 17 Nov 2015 09:11:42 GMT

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 — Tue, 17 Nov 2015 10:10:14 GMT

Hi,

See the attach..

Can u upload ur sample?

BR,

Dinu1

Tue, 17 Nov 2015 10:13:35 GMT

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 — Tue, 17 Nov 2015 10:15:18 GMT

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

try this:

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

Anonymous — Tue, 17 Nov 2015 10:17:37 GMT

or simply like:

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