rank fun?

[#1]

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

how it works explain me pls ?

[#2]

I rank fun pretty highly

[#3]

check the qlikview help.  does that explain you?

[#4]

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.

[#5]

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,,,,,,,,,,,,,,,,

[#6]

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

[#7]

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..

[#8]

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?

[#9]

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

[#10]

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.