topic Re: How to start with google map integration in qlikview dashboards. in QlikView

How to start with google map integration in qlikview dashboards.

Tue, 26 Jul 2011 13:24:11 GMT

Hi,

I would like to learn how to integrate google maps to qlikview dashboards. I am requesting help from experienced hands.

As of now, I have no idea of how to start. I am thinking of starting with a simple example with inline tables.

Country:

LOAD * INLINE [

cities, count,

City1, 12

City2, 13

City3, 35

City4, 66

City5, 9

City6, 45

City7, 8

City8, 52

];

Now I would like to give geographic coordinates to these cities and show them in map so that when i place the mouse over each city, the corresponding measure will be shown as a pop up.

Kindly guide me to begin.

Re: How to start with google map integration in qlikview dashboards.

Tue, 26 Jul 2011 18:52:14 GMT

Look at the attachment and the post

http://community.qlik.com/thread/32382?tstart=0

How to start with google map integration in qlikview dashboards.

Wed, 27 Jul 2011 12:14:48 GMT

Hi JJ,

This link was very helpful and I could start with integrating Google maps to my dashboard.

I have one doubt in this point.

In your file, you are dynamically calculating the coordinates of cities.

I am planning to manually give the credentials as two columns in the script and directly load it.

See the attached files. I have modified your file to include a new set of cities. The google maps shows perfectly in there.

Now I have created another file where am giving these city names and coordinates (those which I got from the first file) as direct columns. But in that file I see issues..definitely due to my lack of experience in QV

1) when i take the expression tab, the cart symbol is showing that of line graph and not of scatter chart. Why is this like that? I dont see an option where i can change the chart type to scatter chart. When i dot it in General tab, then also its not changing.

2) Though the coordinates are same as of the first file, the scatter chart has the bubles in wrong locations in the second chart. Why is it so ?

Kindly help me with these.

How to start with google map integration in qlikview dashboards.

Wed, 27 Jul 2011 12:18:58 GMT

Hi JJ,

I could'nt find an option to attach files while I was replying to ur reply.

So i have attached both the files editing my initial post..kindly download them from there.

Thanks.

Re: How to start with google map integration in qlikview dashboards.

Wed, 27 Jul 2011 19:32:14 GMT

I suspect an issue with the Case sensitive.

In the Inline you write Longitude & Latitude with a capital L. In the chart the formula is with a l

Not tested.

To include a file in a reply, just click in Use advanced editor (top rigth)

Re: How to start with google map integration in qlikview dashboards.

Thu, 28 Jul 2011 07:22:25 GMT

Hi JJ,

I changed the spelling to lower case but still no improvement in the file that I created.

I am attaching my file (GMap_Test2) and the file provided by you which was edited by me to incude the same data there (GeoCode Bulgarian Cities_try1).

No idea why my file is not showing it correctly..this may be a small issue..but am not able to identify the missing part.

Would be really great if you could please help.

Thanks,

Vis

Re: How to start with google map integration in qlikview dashboards.

Thu, 28 Jul 2011 18:52:42 GMT

Hi Vis

I just replace your chart with one of mine, changing the key variable

It works well.

Hope you could produce pretty geodashboard

Re: How to start with google map integration in qlikview dashboards.

Mon, 01 Aug 2011 11:49:04 GMT

Thanks a lot for the help JJ,

Really this was very useful for me to start with including google maps in dashboards.