Qlikview Google Map Integration

[manojkulkarni]

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]

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]

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]

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]

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]

Pls find attachment

[Anonymous]

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]

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

[#9]

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