Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

farheenayesha
Contributor

How to display only 3 countries on google map

Hi,

     I have created a google map where in i want to display only 3 country's name(China, Brazil and Germany) but my map is displaying other countries as well. Can anyone help me to display only the above country names and hide the rest.

Map.PNG

Thanks

7 Replies
sujeetsingh
Honored Contributor III

Re: How to display only 3 countries on google map

This is a little bit complex one you need to then gather only longitude latitude you want the chart to present.

Not applicable

Re: How to display only 3 countries on google map

You can use set analysis to exclude the countries.

Something like this.

SUM({<Country -= {'China', 'Brazil','Germany'}>}CustomerQuantity)

jpenuliar
Valued Contributor III

Re: How to display only 3 countries on google map

Hi Ayesha,

Have you added more countries to your original list of Countries, you can use Zohaib Irshad's suggestion of Set analysis.

But if you still have only 3 countries in your table, now I am assuming you want the names of the countries in your google map to be hidden and just show the 3 country names you have, is that correct?

abh
Contributor II

Re: How to display only 3 countries on google map

Hi Ayesha,

The map you are pulling in is provided by Google, showing an area based upon your points. As you have three points spread over a wide area you will get all of the map in between as well, and by default, Google puts placenames on everything.

I don't believe there is a way to instruct the Google Maps API to remove country names. What kind of effect are you trying to achieve or what story are you trying to tell with this data? If you wish to only show those three countries then you might want to investigate the option of an SVG map using an extension object. This would allow you to show the country outline for only those countries you have in your data.

farheenayesha
Contributor

Re: How to display only 3 countries on google map

Thanks everyone for your reply.

     Yes Jon, it is correct. I am using long and latitude values only for those 3 countries. I think Adam is right. We cant hide other country names. Please let me know if there is any way to hide other than using extension objects.

jpenuliar
Valued Contributor III

Re: How to display only 3 countries on google map

unfortunately that is a limit to using google map, there is also map quest, but labels are also present. it maybe possible if you scour the internet for map api's which matches your requirement

jpenuliar
Valued Contributor III

Re: Re: How to display only 3 countries on google map

Hi Ayesha,

you might be able to achieve your requirement with a bit more research and tweaks.

Enhance Your Qlikview Maps with a Few Simple Tweaks (& fix them if they’ve broken). | QVDesign

Google Maps API Styled Map Wizard

i managed to remove all all labels in Google map by modifying the code in Chart Property>> Dynamic Image (this is basically google map url).

In order for you to show Labels for your Countries in your table, tick Properties>> Presentation>> Labels on Datapoints

Community Browser