topic Re: Rank function in QV12, is it changed? in QlikView

Rank function in QV12, is it changed?

Digvijay_Singh — Thu, 10 Mar 2016 05:39:58 GMT

Hi,

I am finding Rank function behaving differently after installing QV12, I am not finding related discussion in community means I am doing something wrong or missing some basics here.

Here is sample data -

Load * inline [

Dim, Data

A, 5

B, 5

C, 5

D, 6

E, 6

F, 6

];

I want to give rank 4 to A,B,C and 1 to D, E, F. Or want to give individual ranks instead of range in any logical manner. I think it was easily done in QV11 by using 2nd parameter in Rank function, probably 4.

But QV12 shows as below -

In fact no impact of different 2nd parameter I could observe in RANK function.

Thanks in advance!

Re: Rank function in QV12, is it changed?

MayilVahanan — Thu, 10 Mar 2016 05:59:53 GMT

Try like this

Rank(Sum(Data), 4,1)

Re: Rank function in QV12, is it changed?

Digvijay_Singh — Thu, 10 Mar 2016 06:04:10 GMT

Thanks, I should have read 'help' properly.

Re: Rank function in QV12, is it changed?

jagan — Thu, 10 Mar 2016 06:53:13 GMT

HI,

Check this from Qlikview help file

The second parameter mode specifies the number representation of the function result.

mode

0 (default)	If all ranks within the sharing group fall on the low side of the middle value of the entire ranking, all rows get the lowest rank within the sharing group. If all ranks within the sharing group fall on the high side of the middle value of the entire ranking, all rows get the highest rank within the sharing group. If ranks within the sharing group span over the middle value of the entire ranking, all rows get the value corresponding to the average of the top and bottom ranking in the entire column segment.
1	Lowest rank on all rows.
2	Average rank on all rows.
3	Highest rank on all rows.
4	Lowest rank on first row, then incremented by one for each row.

The third parameter format specifies the text representation of the function result.

format

0 (default)

Low value&' - '&high value on all rows (e.g. 3 - 4).

Low value on all rows.

Low value on first row, blank on the following rows.