topic Re: Top in Qlikview in QlikView

Top in Qlikview

Anonymous — Sat, 10 Jan 2015 13:46:14 GMT

Hi ,

How Top is used ? can it be used instead of Rank() in qlikview ?

Re: Top in Qlikview

ecolomer — Sat, 10 Jan 2015 13:59:24 GMT

Here you have examples

Re: Top in Qlikview

rwunderlich — Sat, 10 Jan 2015 17:37:49 GMT

Are asking about the Top() function?. Top() is an chart inter-row function, like above() and below(). The inter-row functions compute an expression using the dimension values on "another" row in the chart. The difference between the inter-row functions above(), below(), top() and bottom() is primarily the starting orientation -- which row of the chart.

Top() could be used in a somewhat similar way to rank(), but not exactly. The top() row is defined by the sort order of the chart. Rank() has no connection to the order of the chart. RownNo() is sort of the chart row equivalent to Rank().

-Rob

Re: Top in Qlikview

Anonymous — Sat, 10 Jan 2015 19:28:13 GMT

thank you Rob for your valuable information .

Re: Top in Qlikview

Gabriel — Sat, 10 Jan 2015 20:39:23 GMT

Hi,

I agree with Rob 100%.

TOP function return the 1st row of the column and you can equally return the last by putting negative number.

You can't substitute TOP function for RANK function they are 2 different functions.

Best Regards,