Discussion board where members can get started with QlikView.
i want to calculate revenue for 2 years , difference and then rank them.
My straight table looks like below. My current Rank expression is rank(Sum([% growth]),0,1)
Market Revnue 2008 Revenue 2010 % growth Rank
A 3800 4369 569 1
B 77 151 74 1
C 58 99 41 1
D 35 74 38 1
E 59 79 20 1
F 28 44 16 1
G 0 0 0 1
Not sure why i am not getting the correct rank. I tried different options of Rank as given in QV help but getting the same results.
Solved! Go to Solution.
I assume you are using more than 1 dimension in your table, right? Rank will be calculated in the context of your column segment.
Try using only 1 dimension or try using a TOTAL qualifier with your rank(TOTAL sum([% growth]),0,1)
Is [% growth] a field or an expression label? If it's a expression label, you shouldn't use an aggregation function around. Try then without the sum or repeat the expression you are using in the referenced expression.
If this is still of no help, could you maybe upload a small sample application that demonstrate your issue?