Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Top in Qlikview

Hi ,

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

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

4 Replies
ecolomer
Master II
Master II

Here you have examples

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Anonymous
Not applicable
Author

thank you Rob for your valuable information .

Gabriel
Partner - Specialist III
Partner - Specialist III

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,