Filtering top 5 selling countries on a map chart

[#1]

Hi,

Is there a way to filter top 5 selling countries on a map chart?

I have Country (country_name) as a point layer and used Sales (sales_amount) in the following expression:

Aggr(Max(sales_amount), country_name)

It's seems that the expression works, but how do I get the top 5 Countries? I tried using 'Rank' in the expression but it only returned 1 Country:

Aggr(Rank(Max(sales_amount),country_name),<=5)

Best regards,

Linas

[#2]

Funny, this shows all the Countries, but top 4 have large circles. Changed from '<= 5' to '<= 6' and can see top 5 selling countries with large (same size) circles + the rest in tiny little circles.

It's not exactly what I have been looking for, but sufficient enough!

Thanks Mario!

[#3]

ok. don't forget to close the thread and mark an answer. so that others can search the forum whenever they come to the same scenario.

[#4]

Strangely, the rest (not top 5) all show same Sales amount... must be a bug..

[#5]

can you send an image of your expression and result ?

[#6]

Hi Mario,

Can you send me your email, as for confidentiality reasons I don't want to post any images on Qlik community page.

Many thanks,

Linas