topic Re: qlikview map coordinates in QlikView

qlikview map coordinates

Wed, 24 Nov 2010 11:21:21 GMT

hi,

I am taking an India map as a background of 3d chart , I want to know the sale of cities of india , as user mouse over on the city area.

How to set the coordinates for cities without using google map

qlikview map coordinates

johnw — Wed, 24 Nov 2010 23:49:14 GMT

Use a scatter chart with X and Y coordinate values either hardcoded to match the map or calculated from latitude and longitude of the cities and of the visible area of the map and the type of projection used for the map. Use sum(Sales) for the Z expression. Mouse over the dot on top of the city to see the sales to the city.

Here's an example of what I'm talking about using a map of China. Obviously the latitude and longitude are fake, but it should give you the idea.

qlikview map coordinates

Tue, 26 Jul 2011 14:05:02 GMT

Hi John,

I would like to learn the basics of including a google map in my qlikview dashboard.

Kindly help me with this.

Re: qlikview map coordinates

vikasmahajan — Sat, 28 Jul 2012 16:49:50 GMT

Dear John ,

Can you share Examples for INDIA (statewise)

Re: qlikview map coordinates

vikasmahajan — Sun, 29 Jul 2012 05:45:35 GMT

Can you give IDEA for INDIA State wise

Re: qlikview map coordinates

Lee_Matthews — Mon, 30 Jul 2012 01:40:01 GMT

Sircute

Its easy to just copy and paste code from an existing application. As long as you have the latitude and longitude data in your application, and as long as you name the fields exactly the same as the application you are copying, it should just work. Attached is a starting point for you.

- Ensure you have the lat & long fields in your data model and that they are named exactly the same

- Copy all of the code from the maps tab in the load script

- Copy and paste the chart objects onto your application

Re: qlikview map coordinates

vikasmahajan — Mon, 30 Jul 2012 06:02:05 GMT

Thanks A Lot I will try get back you.

Re: qlikview map coordinates

vikasmahajan — Mon, 30 Jul 2012 06:02:14 GMT

Thanks A Lot I will try get back you.

Re: qlikview map coordinates

Mon, 30 Jul 2012 10:15:54 GMT

Hi John and lee -

First of all your answers were awesome and professional. Thanks for that.

Besides, I would like to ask a couple of questions that can help me create my own map:

where can i find a web based map that can give me global long & lati data, i.e., a map where I can type in an address (or point at one for that matter) and get its long. & lati. data?
Is there an option to actively move the map with the mouse? lets say i have selected an area, so that now the map is in zoom in mode - now I would like to move the map (in the same zoom in level) to a selected direction - is there a way to do so(just like in googlemaps) ?

Thanks again!

Re: qlikview map coordinates

Lee_Matthews — Mon, 30 Jul 2012 10:40:54 GMT

Hi Evya

Regarding point 1: I don’t know of such a data set. There is a way to call the google API to get lat & long back from an address, which is done in the load script. I have not done this before though, so I don’t have the code. Note that the google API will probably impose some restriction on the number of times you can do that without a licence.

Regarding point 2: You cant do that with the approach of creating your mapping chart using a simple scatter chart and a google image background. Perhaps with a 3rd party add-on you could. There are several available and they typically use an extension object which would have extra functionality specific to mapping.