topic How to display only 3 countries on google map in QlikView

How to display only 3 countries on google map

farheenayesha — Fri, 05 Dec 2014 08:34:41 GMT

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.

Thanks

Re: How to display only 3 countries on google map

sujeetsingh — Fri, 05 Dec 2014 08:41:18 GMT

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

Re: How to display only 3 countries on google map

Fri, 05 Dec 2014 09:50:32 GMT

You can use set analysis to exclude the countries.

Something like this.

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

Re: How to display only 3 countries on google map

jpenuliar — Fri, 05 Dec 2014 10:23:34 GMT

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?

Re: How to display only 3 countries on google map

Anonymous — Fri, 05 Dec 2014 10:29:43 GMT

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.

Re: How to display only 3 countries on google map

farheenayesha — Fri, 05 Dec 2014 13:04:32 GMT

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.

Re: How to display only 3 countries on google map

jpenuliar — Fri, 05 Dec 2014 14:14:57 GMT

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

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

jpenuliar — Fri, 05 Dec 2014 15:23:13 GMT

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