Discussion board where members can learn more about Qlik Sense App Development and Usage.
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...
Go to Solution.
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.
Very helpful! Perfect...