topic Re: Google map - not showing chart in QlikView

Google map - not showing chart

vikasmahajan — Mon, 05 Nov 2012 10:06:46 GMT

Dear All

I have attached excel file having all latitude and logitutde with google map , but india map is not appering

can any one help me to chive the same

Thanks in advanace

Vikas Mahajan

Re: Google map - not showing chart

fdelacal — Mon, 05 Nov 2012 10:35:39 GMT

IN THE EXCEL THE LONGITUDE AND LATITUDE HAVE "," IT WILL BE "."

Try changing that

https://maps.google.es/maps?q=11.651%2C92.7307&oe=utf-8&aq=t&rls=org.mozilla:es-ES:official&client=firefox-a&um=1&ie=UTF-8&hl=es&sa=N&tab=wl

11.651,92.7307

if you put , it not works.

Hope it help you

Re: Google map - not showing chart

vikasmahajan — Mon, 05 Nov 2012 10:43:47 GMT

I have not understand what you want to say ?

can u chage in excel and show me it how ?

pls reply

Re: Google map - not showing chart

fdelacal — Mon, 05 Nov 2012 10:51:04 GMT

in script in qlikview when you load

Latitude

Longitude

You should write

replace(Latitude,',','.') as Latitude,

replace(Longitude,',','.') as Longitude

wiht this you change your problem. the problem is "," coma

Re: Google map - not showing chart

vikasmahajan — Mon, 05 Nov 2012 10:59:45 GMT

Dear Sir,

Changed the same but still problem is there are you able to get the map !

Please help me

Re: Google map - not showing chart

vikasmahajan — Mon, 05 Nov 2012 11:00:59 GMT

I have attached changed qv also for your referenace

thanks

Re: Google map - not showing chart

rajeshvaswani77 — Mon, 05 Nov 2012 11:36:49 GMT

Hi Vikas,

Can you check transparency. This must be 0%. In the presentation tab of the chart you should be able to set this.

thanks,

Rajesh Vaswani

Re: Google map - not showing chart

fdelacal — Mon, 05 Nov 2012 11:54:20 GMT

SEE ATACH HOPE IT HELP YOU

Re: Google map - not showing chart

vikasmahajan — Mon, 05 Nov 2012 12:11:20 GMT

I am thankful to you for helping me please see attachment of map_of_india.jpg file as per that map we require to dispay sales state wise and when I click on state - customer wise sales should display.

Sir give me guide lines.

Thanks

Re: Google map - not showing chart

Fri, 06 Sep 2013 10:20:36 GMT

For generating Map may be it will help u

http://community.qlik.com/docs/DOC-4722

thanx,

Harshal