topic Qliksense Map - Top 10 Country's with highest customers in App Development

Qliksense Map - Top 10 Country's with highest customers

Kandimal — Sat, 16 Nov 2024 18:19:27 GMT

Hi All,

I'm trying to show top 10 country's with highest customers using native map function in qliksense.

from the image, i only want to show the top 10 bubble and the rest should not be shown. I had used the function

=count({<Nationality = {"=Rank(count(distinct CUSTOMER_ID))<=10"}>} CUSTOMER_ID) but not able to get the desired result. Could some one help with this?

Re: Qliksense Map - Top 10 Country's with highest customers

lironbaram — Thu, 23 Jul 2020 16:11:55 GMT

use this expression in your dimension

aggr(if(rank(count(distinct CUSTOMER_ID)<=10,Nationality ),Nationality )

and this for size expression

count(distinct CUSTOMER_ID)

Re: Qliksense Map - Top 10 Country's with highest customers

Kandimal — Fri, 24 Jul 2020 11:16:05 GMT

@lironbaram

thanks for the reply and suggested expression still gives me the same result.

the main problem was due to the dimension property value "Limitation" disable for Nationality column. otherwise would have used Fixed and written the expression in global variable and would have called it under "TOP".

Is there something we could do from Scripting side? like creating a new column to hold some sort of value and calling it in the main report?

Re: Qliksense Map - Top 10 Country's with highest customers

lironbaram — Sun, 26 Jul 2020 07:11:48 GMT

this expression work perfectly on my app

can you share a sample app

Re: Qliksense Map - Top 10 Country's with highest customers

Kandimal — Mon, 27 Jul 2020 10:32:16 GMT

i'm using native map from qlik and using a dimension which contains the country code like - US,UK,IN...etc...(many countries we have in my dimension and in my first shared image )

when I apply the above expression in dimension the pointers/area bubbles in my map get disappear.

I couldn't able to share the sample app due to data policies in my org...also i noticed, the default option we get to limit the dimension value(fixed/limited/range) is also disabled. does it happens with by default qlik application?

Re: Qliksense Map - Top 10 Country's with highest customers

lironbaram — Mon, 27 Jul 2020 11:30:12 GMT

the dimensions in the map doesn't have this option

just to make sure you did replace the expression in the demo with the expression and fields from your app?

Re: Qliksense Map - Top 10 Country's with highest customers

Kandimal — Mon, 27 Jul 2020 11:44:21 GMT

yes, I have replaced it with my actual dimension name in the given expression. since aggr function takes 2 arguments, i have to add "," and ")" at the end to make the syntax work.

aggr(if(rank(count(distinct CUST_ID_NUM)<=10,Nationality ),Nationality ),)

Could you please share your map image or sample app where it's working for you?

Re: Qliksense Map - Top 10 Country's with highest customers

lironbaram — Mon, 27 Jul 2020 15:24:12 GMT

try to replicate this app

Re: Qliksense Map - Top 10 Country's with highest customers

Kandimal — Tue, 28 Jul 2020 09:23:21 GMT

Hi,

Actually I was looking for even better solution since I want only to show TOP 10 values (static always) and found we can actually limit by setting the MAX value to 10 under general property under the created layer.

The dynamic solution you have provided is also a good one when especially user wants to play around the map using a slider object

Thank you