Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
hvfalcao
Contributor

Top Clients on Sense Map

Hello Comunity!

I need a map on Sense, showing only the top 10 clients...

Here is what I'm trying to do on map settings:

Layer: Clients Geopoint

Unchecked show null values

Expression: if(aggr(rank(sum(SALES)),IDCLIENT) <=10, 1,'')

This actually shows on the map all my clients, and give bubble size to the top 10, and a 'X' on the map to the other clients...

The problem is that I just wanna show the top 10 on the map...

Any idea?

Thanks

Henrique

Tags (5)
1 Solution

Accepted Solutions
Employee
Employee

Re: Top Clients on Sense Map

I think so...

What is did is  to also use the color by expression to customize the color of the point based on Top10

My color expression uses the 1st parameter of the arbg() function to establish 100% transparency for NON-top 10 cities

if( aggr(rank(sum(Sales)),City) <=10, argb(255,255,0,0),argb(0,125,125,125))

see if this helps.

2 Replies
Employee
Employee

Re: Top Clients on Sense Map

I think so...

What is did is  to also use the color by expression to customize the color of the point based on Top10

My color expression uses the 1st parameter of the arbg() function to establish 100% transparency for NON-top 10 cities

if( aggr(rank(sum(Sales)),City) <=10, argb(255,255,0,0),argb(0,125,125,125))

see if this helps.

hvfalcao
Contributor

Re: Top Clients on Sense Map

Jonathan,

Very helpful! Perfect...

Thank you