Discussion board where members can get started with QlikView.
I need to create report as attached format.
Go to Solution.
You can try all of these:
Hrank( Column(1), 1, 1)
Hrank( Column(1), 2, 1)
Hrank( Column(1), 3, 1)
Hrank( Column(1), 4, 1)
View solution in original post
So what is the issue? What exactly are you not able to do?
Am not understand how to do this...
You need to do transpose and Rank expression
Expression : Sum(Values)/100000
Number format should fixed to Zero
Is the rank not working? Or what is the issue, try HRank(Column(1)) for rank, if that that is your issue
You really genius Sunny...
But in the rank I am getting like 1-25, 1-5 .
Please explain HRank function...
HRank is same function as rank but can be used in a pivot table for the pivoted dimension. Read here:
If i want to add another expression Like YTD sale then how can achieve this
I want month wise ranking over the company.
Please find the attachment