Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Google maps in Sense

Hi,

I have a list of post codes with latitude and longitude grid. I need to show these locations on google maps in Sense. Can someone guide please?

1 Solution

Accepted Solutions
abhaysingh
Contributor III

Re: Google maps in Sense

Hi Sarb Nyota..

try like this

load

     field1,

     field2,

     lattitude,

     longitude,

     geomakepoint(lattitude, longitude) as Geokey

from .....

than on ui simply drag MAP chart and add geokey as measure.

thanks

Abhay

4 Replies
abhaysingh
Contributor III

Re: Google maps in Sense

Hi Sarb Nyota..

try like this

load

     field1,

     field2,

     lattitude,

     longitude,

     geomakepoint(lattitude, longitude) as Geokey

from .....

than on ui simply drag MAP chart and add geokey as measure.

thanks

Abhay

Not applicable

Re: Google maps in Sense

Thanks Abbay, that seems to work now. the results show me that my latitude and longitude location is not right.

Do you know where can I find a list of all post codes with latitude and longitude information?

abhaysingh
Contributor III

Re: Google maps in Sense

No Sarb sry i cant help in this, but organization has to maintain their Database in that case no one can provide you such data if you want word standard data like county/city etc lat long than u can find it on excel..but apart from that i dont think any one can help.

and you cant represent right data until and unless you have right lat long.

thanks

abhay

Not applicable

Re: Google maps in Sense

Thanks Abbay,

I found this link that gave me latitude and longitude location for my postcodes

Postcode Batch Converter | UK Grid Reference Finder

Thanks for all your help on this

Community Browser