topic help needed on rank() in QlikView

help needed on rank()

Sun, 06 Dec 2015 14:05:00 GMT

Hi All,

Hope all are doing good..

i need help on regarding rank().

i have month,sales,country fields and in a line chart i need to show top 5 countries sales(5 lines) against month dimension.

for first expression i need to show top country sales over month and for second exp i need to show second top country sales like this i need to display for top 5 countries.

please help me with the expressions.

Thanks in advance,

Nani.

Re: help needed on rank()

swuehl — Sun, 06 Dec 2015 14:09:19 GMT

I assume you want to rank after total sales, not per month (latter should not work really good in a line chart).

Use month field as 1. dimension, then country field as second dimension and as expression

=Sum({<country = {"=Rank(Sum(sales))<=5"}>} sales)

Re: help needed on rank()

Sun, 06 Dec 2015 15:08:35 GMT

thanks swuehl for the solution.your expression fulfilled my requirement.

thanks for correcting me.