topic Re: Ranking based on deviation from zero in QlikView

Ranking based on deviation from zero

Tue, 08 Aug 2017 09:20:00 GMT

Dear Experts,

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.

For Example

A quick response will be appreciated.

Regards,

Prashant Karanjgaonkar

Chanty4u — Tue, 08 Aug 2017 09:36:20 GMT

try

=Firstsortedvalue(percentage,Field)

Tue, 08 Aug 2017 10:14:58 GMT

Hi,

thanks for quick reply.

Can you help with a test application.

Chanty4u — Tue, 08 Aug 2017 10:16:53 GMT

simple example read below

techvarun — Tue, 08 Aug 2017 10:27:57 GMT

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

Tue, 08 Aug 2017 10:46:47 GMT

Please use following expression

Rank((vMaxValue-VALUE)*(if(VALUE>=0,1,-1)))

Tue, 08 Aug 2017 10:47:15 GMT

Rank((vMaxValue-VALUE)*(if(VALUE>=0,1,-1)))

pathiqvd — Tue, 08 Aug 2017 11:04:14 GMT

Hi,

Try this you will get solution,

=aggr(rank(if(Percentage>0,$(=max(Percentage))-Percentage,Percentage-$(=max(Percentage)))),Percentage)

Regards,

Wed, 09 Aug 2017 06:46:36 GMT

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.