topic Re: Google maps Implementation on Scatter Chart in QlikView

Google maps Implementation on Scatter Chart

Wed, 20 May 2015 11:32:13 GMT

Hi All,

I am new to Qlikview and facing an issue while plotting scatter graph in google maps using Qlikview.

PFA QVW file for your reference. I am also attaching the reference doc from which I am taking help to learn this.

I am able to plot scatter chart ; However when I try integrating it on google maps, scatter chart vanishes.

On digging , I found that when I enter below values in Expression tab , This issue occurs:

Longitude:

=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())))))

I am taking reference from the word doc which is attached as well.

Please help me on this.

Puneet.

Re: Google maps Implementation on Scatter Chart

jpenuliar — Wed, 20 May 2015 13:04:52 GMT

Hi Puneet,

you have to make sure the Fields longitude and latitude matches (in case) the names you used in expression.

fields: longitude,latitude

expression: Longitude,Latitude

Qlikview is case sensitive, values must match

Re: Google maps Implementation on Scatter Chart

manojkulkarni — Wed, 20 May 2015 13:24:16 GMT

Latitude & Longitude & Dynamic image is not mentioned. Follow the instruction from document it should work,.

Re: Google maps Implementation on Scatter Chart

Wed, 20 May 2015 14:10:10 GMT

Hi Manoj,

I have followed all the instructions as per the document but scatter graph vanishes when I define Longitude/Latitude and put values for X and Y Axis for Static Min/Max .

Puneet.

Re: Google maps Implementation on Scatter Chart

Thu, 21 May 2015 08:07:17 GMT

Thanks . Its done.