topic Re: Qlikview Google Map Integration in QlikView

Qlikview Google Map Integration

manojkulkarni — Fri, 13 Feb 2015 09:51:28 GMT

I have integrated Google Maps in QLikview using google api. I would able to plot the map but not able to show the city name on mouseover of dots.

I would also want to show the dots in green or red on the basis of positive or negative value respectively.

AbhijitBansode — Fri, 13 Feb 2015 10:05:38 GMT

I Believe you have use scatter chart for plotting longitude and latitude.

To change the color of dots, assign background color to your actual expression in the scatter chart.

For mouseover effect, add one more expression to the chart, setting text on pop up property.

Anonymous — Fri, 13 Feb 2015 10:06:36 GMT

I suppose that City Name is the Dimension and "Popup Labels" (Tab Presenation) is defined

then in my case it works

to get different colours Qlikview works different when I expected

you Need to define the Background colour of the first Expression (longitude in my case)

e.g. if (Value<0.5,rgb(0,64,64),rgb(128,0,128))

The dots are showing in different colours

I would have expected to define the Background colour for the Expression Value (but that doesnot work)

Hope that helps for you as well

manojkulkarni — Fri, 13 Feb 2015 10:28:39 GMT

When we enable Popup labels, i will get city name along with latitude & longitude.

For coloring, I am doing same as suggested but still no result.

Anonymous — Fri, 13 Feb 2015 10:51:02 GMT

you cannot define that only cityname will be displayed (for my knowledge)

with the Background I am not sure, as it works in my case.

can you append your app (if it is not too Long, maybe only with the Google map?)

manojkulkarni — Fri, 13 Feb 2015 10:58:44 GMT

Pls find attachment

Anonymous — Fri, 13 Feb 2015 12:38:46 GMT

I got it! I had to Change sum([Sales Growth]) in Expression to sum(fabs[Sales Growth]))

set attached app

I changed the colours, so use your colour definition

manojkulkarni — Fri, 13 Feb 2015 17:20:23 GMT

Thanks Rudolf, How to get city name with sales value on mouse over ?

Fri, 27 Feb 2015 00:04:39 GMT

Very helpful - thanks you!! Do you know if you can have bubbles and lines (between locations) on one map, please?