topic Has anyone had luck using the Google maps app? in QlikView

Has anyone had luck using the Google maps app?

james — Thu, 21 May 2009 00:26:32 GMT

I cannot get it to work using any diemnsion at all...

Lat and Long is tied to City

Has anyone had luck using the Google maps app?

Thu, 21 May 2009 00:39:13 GMT

Hello James,

No problems over here, it works flawlessly. Please let me know which problem you encounter, or post your application so I can fix it for you.

regards Mark

Has anyone had luck using the Google maps app?

james — Thu, 21 May 2009 01:13:00 GMT

I have every city linked to a long and lat. For dimension I have used shipping customer, whcih links to a city whioch lnks to the coordinates.

No bubbles appear at all? I would assume the sum of the revenue would populate each "Bubble" based on the coordinates, yet i never see any

Has anyone had luck using the Google maps app?

james — Thu, 21 May 2009 02:43:25 GMT

Has anyone had luck using the Google maps app?

Thu, 21 May 2009 05:41:38 GMT

Somehow, your QlikView datamodel requires the dimension to be a keyfield. Try link_SalesDocument as dimension and the bubbles will show up. I can't give you an answer at this moment why other dimension fields don't work.

regards Mark

Has anyone had luck using the Google maps app?

Thu, 21 May 2009 05:53:27 GMT

Ok, I think i figured it out. Because you have multiple longitude and latitude coordinates in most of your dimensions (cities), the expressions to calculate the bubble position based on the latitude and longitude and the zoom values does not result in the right x and y positions. When you for instance use avg() instead of sum() in these expressions the result is better, but I don't know if this creates other problems.. If I have more time I will do some tests.

regards Mark

Has anyone had luck using the Google maps app?

james — Thu, 21 May 2009 22:50:13 GMT

Mark, isnt that the point of this to have multiple long and lat? Each city I have has 1 coordinate. Yet I have over 1600 cities....

Has anyone had luck using the Google maps app?

Fri, 22 May 2009 00:13:55 GMT

I use customer name as my dimension and each customer has one longitude and latitude. When I use customer city as dimension I have multiple logitudes and latitudes. The best solution is to place the bubble in the centre of the coordinates by using avg() in the expression.

Has anyone had luck using the Google maps app?

ltimmermans — Thu, 01 Mar 2012 22:08:54 GMT

did you try looking at the transparency on the colour tab. The transparancy for the backgroundcolour needs to be set to 0%. That did the trick for me.