topic Calculating ranks in QlikView

Calculating ranks

deepakqlikview_123 — Wed, 27 Aug 2014 12:03:25 GMT

Hi All,

I haveques as per below,
1 How to calculate rank for negative numbers

2How to calculate rankif there are both positive and negative numbers.

thanks,

Deepak

Gysbert_Wassenaar — Wed, 27 Aug 2014 12:19:12 GMT

Use the rank() function. Multiply by -1 if you want to rank from smallest to largest value so that the smallest value gets a rank of 1.

jagan — Wed, 27 Aug 2014 12:29:47 GMT

Hi Deepak,

Use Rank() like below

For Example

Dimension: Employee

Measure: Rank(Sum(Sales))

Employee with highest sales receives Rank1, and so on. Whether it is positive or negative the rank is calculated based on the numbers.

Regards,

Jagan.

deepakqlikview_123 — Wed, 27 Aug 2014 12:33:35 GMT

Thanks both of you