topic Re: Map Integration with Postal code in QlikView

Map Integration with Postal code

Tue, 17 Sep 2013 06:37:04 GMT

Hi All,

I want to show customer information with postal code in a Map. Can any one pls help me how to integrate map with postal code.

Any help would be appreciated.

Thanks in Advance.

Re: Map Integration with Postal code

vikasmahajan — Tue, 17 Sep 2013 06:39:42 GMT

Hii

Refer my link

http://community.qlik.com/thread/65440

Hope this helps you

Vikas

Re: Map Integration with Postal code

Tue, 17 Sep 2013 06:59:37 GMT

Hi Vikas,

Thanks for ur quick respose.

But, I want to show customer information with postal code in a map

Thanks

Arun

Re: Map Integration with Postal code

vikasmahajan — Tue, 17 Sep 2013 07:01:32 GMT

Instead of Lat ./ Longi take PIN Codes and customer in excel load the same and map.

Vikas

Re: Map Integration with Postal code

Tue, 17 Sep 2013 07:20:30 GMT

I have tried, but i am not getting. Can u pls share the application which u hav done with pincode.

Thanks

Re: Map Integration with Postal code

Tue, 17 Sep 2013 07:26:35 GMT

Is there any possibility with Bing Maps or SGV reader to integrate with postal codes.

Pls help me

Thanks

Re: Map Integration with Postal code

Tue, 17 Sep 2013 08:25:00 GMT

Hi Arun,

If you have postal code field then use in Label within Expression...

hope this will help

Thanx

Harshal

Re: Map Integration with Postal code

Tue, 17 Sep 2013 09:53:55 GMT

I dont have latitude and longitude data for UK. I have only postal code. how to integrate the map with postal code.

Thanks

Re: Map Integration with Postal code

Tue, 17 Sep 2013 09:56:18 GMT

Please any one can help me to integrate the map with postal code but not with latitude and longitude.

Thanks.

Re: Map Integration with Postal code

jagan — Tue, 17 Sep 2013 10:02:55 GMT

Hi Arun,

Get the Latitude and Longitudes for Postal codes using below URL

http://www.freemaptools.com/download-uk-postcode-lat-lng.htm

Hope this helps you.

Regards,

Jagan.

Re: Map Integration with Postal code

Tue, 17 Sep 2013 10:13:18 GMT

Get latitude and longitude data for UK or as per yur location from here:

http://www.whatsmygps.com/

http://www.worldatlas.com/aatlas/latitude_and_longitude_finder.htm

Biologika Meio Ambiente e Tecnologia - Conversão DMS / Graus Decimais / DMS

Thanx

Harshal

Re: Map Integration with Postal code

Fri, 15 Jul 2016 17:57:55 GMT

Hi Arun,

You will need a look up table for ZIP codes with its corresponding Latitude and Longitude. And that ZIP code is joined to your customer table's ZIP.

Once this has done, try using GeoMakePoint() Function play around with your measure!

Hope this has helped