topic Re: rank fun? in QlikView

rank fun?

Wed, 16 Jul 2014 17:12:56 GMT

Aggr(Rank(Sum(Value),1,1),ID)

how it works explain me pls ?

Re: rank fun?

Wed, 16 Jul 2014 18:26:45 GMT

I rank fun pretty highly

Re: rank fun?

Wed, 16 Jul 2014 18:27:41 GMT

check the qlikview help. does that explain you?

Re: rank fun?

Wed, 16 Jul 2014 18:28:12 GMT

No but seriously, from the QV helpfiles:

rank([ total ] expression [ , mode [, format ] ])

Evaluates expression, compares the result with the result of the other rows containing the current column segment and returns the ranking of the current row within the segment.

Re: rank fun?

Thu, 17 Jul 2014 04:39:02 GMT

Table:

load * Inline

[ID,Value

111,23

222,34,

333,54

444,11

555,36

666,5

777,54]; pls explain above condition how it is calculating pls,,,,,,,,,,,,,,,,

Re: Re: rank fun?

Thu, 17 Jul 2014 11:57:52 GMT

Here's a QVW that may help you..... if you could explain what kind of expression you're trying to write that would be a little more helpful, champ

Re: rank fun?

Thu, 17 Jul 2014 12:13:23 GMT

perhaps what you are looking for is this function:

rank(aggr(sum(value), ID),1,1)

This function will assign a rank to each ID based on the sum of their values..

Re: rank fun?

Thu, 17 Jul 2014 12:14:42 GMT

M-Buddy,

Are you trying to find an expression that works for a given purpose, or are you trying to figure out how something works that somebody else wrote for you?

Re: rank fun?

Thu, 17 Jul 2014 16:52:27 GMT

i want know how it works what 1,1, work here and id work?

Re: rank fun?

Thu, 17 Jul 2014 16:56:55 GMT

The 1's are the parameters for the rank function:

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).
1	Low value on all rows.
2	Low value on first row, blank on the following rows.