topic Re: How to show pushpin in Google map in QlikView

How to show pushpin in Google map

ananyaghosh — Mon, 18 May 2015 10:50:56 GMT

hi,

I have used scatter chart to build a google map, where I have to use pushpin instead of small rounded image. So how to do that?

Re: How to show pushpin in Google map

sunny_talwar — Mon, 18 May 2015 11:11:56 GMT

For adding pins you can use this code in your dynamic image:

'&markers=size:mid|color:red|32.9440120,-85.9538532' &

I did it for just one spot, but you can make it dynamic by using a concat function on Latitude & longitude and separate each of them with a pipe (|)

you can specify 3 sizes: mid, tiny, and I think the third is big or large and there are different color's available too...

I hope this will help (PFA)

Best,

Sunny !

Re: How to show pushpin in Google map

ananyaghosh — Mon, 18 May 2015 11:30:52 GMT

Can u give me an sample application, so that I can view how it is implemented?

Re: How to show pushpin in Google map

sunny_talwar — Mon, 18 May 2015 11:56:15 GMT

I did attach the Google Map.qvw back with my previous post. Did you look at it?

I think you are looking for this? Are you not?

Best,

Sunny

Re: How to show pushpin in Google map

ananyaghosh — Mon, 18 May 2015 14:10:51 GMT

Hi,

I have used this ones

='http://maps.google.com/maps/api/staticmap?center='

num(var_mid_lat, '##############', '.', ',' )

','

num(var_mid_long, '##############', '.', ',' )

'&zoom=$(var_zoom)'&

'&markers=size:mid|color:red|'&var_mid_lat&','&var_mid_long

'&maptype='&var_maptype

'&size='&map_size_x&'x'&map_size_y

'&Client=gme-cushmanwakefield&sensor=false&.jpg'

But still did not get push pin for every marks on the map, so it only show one push pin. How can I show pushpin for each and every red spot on the map?

Re: How to show pushpin in Google map

sunny_talwar — Mon, 18 May 2015 15:40:14 GMT

You will need to create a variable:

vVar = Concat(latitude & ', ' & longitude, '|')

and then use it something like this:

'&markers=size:mid|color:red|'& vVar (or $(vVar)) & Chr(39) &

The idea is to provide a list of latitude and longitude to markers in this form 'Lat1, Long1|Lat2, Long2|Lat3, Long3'

I have a busy day today otherwise would have helped you in the implementation in the sample data.

HTH

Best,

Sunny

Re: How to show pushpin in Google map

ananyaghosh — Wed, 20 May 2015 14:56:27 GMT

It does not work.please give me an QVW file for that. Otherwise it does not under stable to me.

Re: How to show pushpin in Google map

sunny_talwar — Wed, 20 May 2015 14:59:11 GMT

Will work on a dummy file and send it to you in next couple of days

Best,

Sunny

Re: How to show pushpin in Google map

ananyaghosh — Wed, 20 May 2015 15:00:29 GMT

Can u give me to me tomorrow. I have to show it to my clients.

Re: How to show pushpin in Google map

sunny_talwar — Thu, 21 May 2015 10:33:35 GMT

I will work on this today, I hope I am not too late and will post it as soon as I am something.

Best,

Sunny

Re: How to show pushpin in Google map

ananyaghosh — Wed, 27 May 2015 13:55:45 GMT

Hi,

Can u please send me the file? I am waiting for your reply. It is very urgent for me.

Re: How to show pushpin in Google map

sunny_talwar — Wed, 27 May 2015 14:06:58 GMT

Here have a look at the attached file.

HTH

Best,

Sunny

Re: How to show pushpin in Google map

ananyaghosh — Wed, 27 May 2015 14:22:53 GMT

hi,

Thank you very much for your prompt reply. Can it be show information on hovering pushpin? currently only when I hover on the spots, information is showing.

Re: How to show pushpin in Google map

sunny_talwar — Wed, 27 May 2015 14:25:26 GMT

What information? Not sure what you mean?

Re: How to show pushpin in Google map

ananyaghosh — Thu, 28 May 2015 10:57:33 GMT

Actually when I hovering on colored spot, corresponding 'City Name', 'Logitude' and 'Latitude' is showing. But when I hovering over the pushpin, corresponding 'City Name', 'Logitude' and 'Latitude' are not showing.

So, Is it possible to show those info?

Re: How to show pushpin in Google map

sunny_talwar — Thu, 28 May 2015 10:58:51 GMT

I have seen that option before, but I haven't implemented it before. Let me see if I can get some details on that.

Best,

Sunny

Re: How to show pushpin in Google map

ananyaghosh — Fri, 05 Jun 2015 05:26:20 GMT

Hi,

I am chasing you with much delay, as my client want to show information on hovering on pushpin. SO can you please work on that feature for me ?

Please give me some time to resolve this issue as I need to show information on hovering on pushpin also. Please take some time for me.

Thanks,

Sandip

Re: How to show pushpin in Google map

sunny_talwar — Fri, 05 Jun 2015 11:09:47 GMT

Checking it now

Please no more requests after this

Best,

Sunny

Re: How to show pushpin in Google map

ananyaghosh — Wed, 10 Jun 2015 05:57:21 GMT

Hello Sir,

Is there any update on this? I am looking forward for your reply. Please work on this to get some time from your busy schedule.

Thanks,

Sandip Ghosh

Re: How to show pushpin in Google map

sunny_talwar — Wed, 10 Jun 2015 08:42:13 GMT

Unfortunately Sandip, I am unable to find a way to do this. I tried couple of things, but I am not able to achieve what you wanted. I apologize for keeping you waiting for this very long.