topic Re: Rank function for top 15 sales in QlikView

Rank function for top 15 sales

Tue, 04 Feb 2014 07:46:17 GMT

Hi,

can any body give expression to find the top 10 sales of country.

dimensions are country and customer for grouping.tell me how rank function is advantage over dimension limit property.

regards

Mahesh

Sokkorn — Tue, 04 Feb 2014 07:52:57 GMT

Hi Mahesh,

Here is sample one: Sum({$<Country = {"=Rank(Aggr(Sum(Sales),Country))<= 10"}>} Sales)

Regards,

Sokkorn

Tue, 04 Feb 2014 07:56:49 GMT

i am expecting answer with out set analysis.

regards

Mahesh

Sokkorn — Tue, 04 Feb 2014 07:57:57 GMT

Or you can play around with attached file.

Regards,

Sokkorn

Sokkorn — Tue, 04 Feb 2014 08:00:37 GMT

Maybe this one: Sum(If(Aggr(Rank(Sale),Country)<=15,Sale))

Regards,

Sokkorn

Tue, 04 Feb 2014 08:40:21 GMT

can u pls resend the attached file

Tue, 04 Feb 2014 08:40:55 GMT

PFA

Sokkorn — Tue, 04 Feb 2014 08:41:35 GMT

Here you are

Tue, 04 Feb 2014 08:49:30 GMT

Try This dude,

=If(Aggr(Rank(Sum(Sales)),Customer,Country)<=10,Sum(Sales))

You can change the grouping order as per the requirement.