topic Google maps showing data values in QlikView

Google maps showing data values

zagzebski — Mon, 18 Aug 2014 19:21:53 GMT

I have the following three expressions in my google maps chart...

longitute = sum( round (256*pow(2,($(var_zoom)-1)))+( longitude *((256*pow(2,$(var_zoom)))/360)) )

latitude = sum(((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi()))))

Member Count = dual([Member ZIP Code] & ' : ' & num(Sum([Member Count]), '$#,##0'), Sum([Member Count]))

Everything is working however when I hover over the map I get the following (as an example):

Group Name = ABC Supply

longtitude = 15467.12

latitude = 13456.54

120

What I really want is just the group name (which is the dimension) and the member count like

ABC Supply : 120

I have seen it this way in other examples but I can't get it to work for me.

Thanks in advance....

Re: Google maps showing data values

Mon, 18 Aug 2014 19:31:18 GMT

First add a new expression with what you want displayed on hover (ABC Supply: 120). Select 'Text as Pop-up' for this expression, and uncheck this option for all other expressions. Then on the Presentation tab uncheck 'Pop-up Labels' under 'Labels in Chart.'

Re: Google maps showing data values

JonnyPoole — Mon, 18 Aug 2014 19:48:19 GMT

Also - i noticed some buggy behaviour between recent 11.2 SRs . If the above isn't work, kindly share the exact version you are testing with (help -> about QlikView)

Re: Google maps showing data values

zagzebski — Mon, 18 Aug 2014 20:51:47 GMT

using 11.20

Re: Google maps showing data values

zagzebski — Mon, 18 Aug 2014 20:55:16 GMT

I added the following expression:

([Member ZIP Code]&':'& Sum([Member Count]), Sum([Member Count]))

I select this as a Text as a Pop-Up and deselected for Longitiude and Latitude.. also unchecked "Pop up Labels on Presentation tab.

Now the only thing that shows up is the sum of Member Count. Can't get the "Member ZIP" to precede it like in the Dual expression above.

Re: Google maps showing data values

JonnyPoole — Mon, 18 Aug 2014 21:09:28 GMT

try only([Member ZIP Code]) & ': ' & Sum([Member Count]