Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
How Top is used ? can it be used instead of Rank() in qlikview ?
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
Here you have examples
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
thank you Rob for your valuable information .
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,