topic Re: WHy is this Rank function used ?? in QlikView

WHy is this Rank function used ??

nikhilgarg — Mon, 12 Jan 2015 09:44:37 GMT

HEy,

WHy is this Rank function used ??

Just for ranking the values from high to low? Is it so ?

Thanks

Gysbert_Wassenaar — Mon, 12 Jan 2015 10:03:46 GMT

The rank function is used to calculate the rank of a value in a list of values returned by an expression. See the help file for details.

its_anandrjs — Mon, 12 Jan 2015 10:10:42 GMT

Hi,

Rank function is use to give Rank to the expression or Metric values

Ex:-

LOAD * INLINE [

Item, Sales

A, 500

B, 300

C, 100

D, 150

E, 600

];

If you create the straight chart

Dim:- Item

Expre:- Sum(Sales)

Expre:- Rank(Sum(Sales))

By this you can rank the expression

And when you get this details you can find min or max values or Top N values.

Regards

Anand