Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Qlik Sense with Map chart it is easy to create ?

‌Hi All

i have try to link my sales table with map info in the pass , I remember I need to find out individual customer their Google map location on Longtitute and attitute , which require a lot effort and I give up doing it.

after stopping for few year , I like to try again . can some one share with me any new extension or any new approach can make like more easy and simple ?

I Refer to customer from sourthen east Asia

paul

1 Solution

Accepted Solutions
kjhertz
Partner - Creator
Partner - Creator

Yes to plot your customers on a map in Qlik Sense you need to convert their address into geographic coordinates such as latitude and longitude. There are several paid services which can provide coordinates and even area polygons for zip codes. I think Qlik Data Market can have coordinates for several countries so that may be worth checking out.

If you have a tight budget or just want to try mapping in Qlik Sense I recommend using Google Maps API for converting your adresses to coordinates:

https://developers.google.com/maps/documentation/geocoding/intro

You need to login with a Google account and get an API Key that will be used in your API request. The Google Maps API supports http(s) request which can be handled by Qlik Sense (as a web file data source) and the request will return a XML file where you can filter out the latitude and longitude for the adress (or search term) you have requested.

For example to get the coordinates for the city Malmö in Sweden I can use this https request:

https://maps.googleapis.com/maps/api/geocode/xml?address=sweden+Malm%C3%B6&key=APIKEY

Since it's not practical to set up a data connection in sense for every customer you need to disable Standard Mode in Qlik Sense (See 'Disabling standard mode' chapter in Qlik Sense help) so that you may use a variable and $-sign expansion for your address part of the request:

https://maps.googleapis.com/maps/api/geocode/xml?address=$(vAddress)&key=APIKEY

Finally you put the request string in a loop where you run through your customer's adresses and save the latitude and longitude to a table that you can use in your Qlik Sense Maps!

Note: The Google Maps API have a limit of 2500 requests per day (as of August 2016) with options to buy more. But that would be enough for most applications I guess..

View solution in original post

8 Replies
paulyeo11
Master
Master
Author

Does any one know what it the easy solution for this question ?

kjhertz
Partner - Creator
Partner - Creator

Yes to plot your customers on a map in Qlik Sense you need to convert their address into geographic coordinates such as latitude and longitude. There are several paid services which can provide coordinates and even area polygons for zip codes. I think Qlik Data Market can have coordinates for several countries so that may be worth checking out.

If you have a tight budget or just want to try mapping in Qlik Sense I recommend using Google Maps API for converting your adresses to coordinates:

https://developers.google.com/maps/documentation/geocoding/intro

You need to login with a Google account and get an API Key that will be used in your API request. The Google Maps API supports http(s) request which can be handled by Qlik Sense (as a web file data source) and the request will return a XML file where you can filter out the latitude and longitude for the adress (or search term) you have requested.

For example to get the coordinates for the city Malmö in Sweden I can use this https request:

https://maps.googleapis.com/maps/api/geocode/xml?address=sweden+Malm%C3%B6&key=APIKEY

Since it's not practical to set up a data connection in sense for every customer you need to disable Standard Mode in Qlik Sense (See 'Disabling standard mode' chapter in Qlik Sense help) so that you may use a variable and $-sign expansion for your address part of the request:

https://maps.googleapis.com/maps/api/geocode/xml?address=$(vAddress)&key=APIKEY

Finally you put the request string in a loop where you run through your customer's adresses and save the latitude and longitude to a table that you can use in your Qlik Sense Maps!

Note: The Google Maps API have a limit of 2500 requests per day (as of August 2016) with options to buy more. But that would be enough for most applications I guess..

paulyeo11
Master
Master
Author

Hi Jonas

Thank you very much for share with me the free options.

I will Google into it to look for more info.

Paul

Sent from my iPhone

Not applicable

Hi Paul,

Just so you know, IdevioMaps does geocoding on the fly, so you can use city names instead of long and lat to place the customers.

Thanks,

Patric Nordström, Idevio

Try IdevioMaps for Qlik Sense, QlikView and GeoAnalytics Connector at QlikMarket or watch the highlights on video.

paulyeo11
Master
Master
Author

Hi Pat

May I know how do you charges for the service ?

Paul

Sent from my iPhone

Not applicable

Hi Paul,

IdevioMaps is commercial add-on for QlikView and Qlik Sense.

Please use our contact form to get in contact with us for test licenses and pricing!

Thanks,

Patric

paulyeo11
Master
Master
Author

Hi Pat

Thank you for your info

Sent from my iPhone

Anonymous
Not applicable

Hi, 

can you provide a example of how you would write this up in qlik sense so that it will do as you mention?

 

Thank you