Discussion Board for collaboration related to QlikView App Development.
We are having a business requirement where we want to rank the values based on deviation from zero.
the value which is having lowest positive difference from zero will get the rank 1.
Next postitive deviation will get rank 2. Then lowest negative difference will get rank 3 and so on.
A quick response will be appreciated.
May be use a hidden expression like below
If(Percentage> 0,100- Percentage, Percentage -100)
and try Rank(Column(1)) as the actual rank expression
superbbbbbbbb Amit Dubey.
Also thanks to Prashant ,for such type of problem statement
Amit dubey ,can provide one test application for this,if yes it is very helpful.