topic Re: Google map in qlikview in QlikView

Google map in qlikview

mohanrajsubrama — Mon, 07 Jan 2013 09:54:30 GMT

Hi Everyone,

Some how I have tried to implement google map in Qlikview.Its is getting drill down still the city wise .

But i could not able to See the Sales data as per city wise as a data point on the map.Some where i am wrong with the expression in lat and long.

I have attached my QVW File here.So Guys Help me with this where i am Wrong and Suggestions are also appriciated.

ragards,

Mohanraj Subramanian.

Re: Google map in qlikview

Mon, 07 Jan 2013 12:16:44 GMT

Hi,

I am not able to open ur qvw file, bez I am using personal edition.

I have attached my sample, PFA.

Regards,

Kabilan K

Re: Google map in qlikview

mohanrajsubrama — Tue, 08 Jan 2013 06:21:41 GMT

Hi Kabilan ,

Thanks for ur Quick reply.i saw ur file and the expressions.

Actually my requirement is if i select any state in india the cities under those state should get populated in the map with their sales as data points.

1)I got lat and log for every cities in india.and for every cities they have their own sales .

But i am still getting struct with this lat and log expressions .Any suggestion about this .

And Attached is the sample excel which iam trying to acheive.

Regards,

Mohanraj Subramanian.

Re: Google map in qlikview

vikasmahajan — Thu, 10 Jan 2013 06:00:04 GMT

Add one more expression for city in your map you will able to see the sales.

Re: Google map in qlikview

Thu, 10 Jan 2013 14:43:18 GMT

Hi Mohanraj,

You have two problems in your application :

1) there's more than one latitude and one longitude per city in your file, so when you load this table you need to use the command "distinct" like this :

LOAD distinct [Region Code],

[Branch Code],

Branch as City,

latitude,

longitude

FROM

(ooxml, embedded labels, table is Branch);

2) in the chart properties, in the Axes tab, you need to uncheck the option "Forced 0" for the X absis and the Y absis

Hope it helps.

Regards,

Nicolas G

Re: Google map in qlikview

mohanrajsubrama — Fri, 11 Jan 2013 05:57:14 GMT

Hi Nicolas,

Its working.I am missing the second step uncheck 'force0' .But ur first suggestion not worked out.i have tried distinct in the script.But Even though the data points on the map is not on the proper location .

Is there any way to make the data points to sit on the same location in the map?

Regards,

Mohanraj Subramanian.

Re: Google map in qlikview

Tue, 25 Feb 2014 10:00:20 GMT

Please find the attached file