Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
why you are having - Column(5))??
try this:
=Rank(Total <Column(5)/Column(10)>,4)
Hi,
See the attach..
Can u upload ur sample?
BR,
Dinu1
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.
why you are having - Column(5))??
try this:
=Rank(Total <Column(5)/Column(10)>,4)
or simply like:
=Rank(-L3/V3,4) //where -L3/V3 is your expression name of 1st column