How to create Map based on ZIP codes in Qliksense

[lakshman1031]

Hi All,

I have a sales table with fields like zip code and Sales. I would like to display the data on a map.

I'm trying to utilize the ZIP code, but it doesn't function without the latitude and longitude.

However, there are no latitude and longitude fields in my source.

Can you please suggest me how to create Map based on the zip codes.

Thanks & Regards,

Lakshman

[JandreKillianRIC]

Hi @lakshman1031 

Add a map object, Area layer. Change the Location type to ZIP / Postal Code

Enter the country. (If you have multiple countries this can be a field in the data model as well) 

Regards Jandre

[lakshman1031]

Hi Jandrekillian,

Thank you for your replay.

I have two tables like "ZIP Code and "Data".

ZIP Code
ID	Country	Region	ZIP_Code
1001	US	Central	30293
1001	US	Central	41824
1001	US	Central	47547
1001	US	Great Lakes	33317
1001	US	Great Lakes	46711
1001	US	Great Plains	44305
1001	US	Great Plains	50128
1001	US	Great Plains	66948
1001	US	Great Plains	55447
1001	US	Mid-Atlantic	64112

Data Table :

Region	Sales
Central	150
Great Lakes	50
Great Plains	250
Mid-Atlantic	300

Output :

I want to show data like above images in Map.

For example Central having 3 zip codes and these codes forming a triangle shape and showing sales data. same way in each region i want to show forming shape and show the data.

Can you please suggest me this requirement is possible in Qlik or not.

If possible can you please suggest me how to do, if not possible can you please suggest me alternatives way to achieve this requirement.

Thanks & Regards,

Lakshman

[JandreKillianRIC]

Hi @lakshman1031 

This is a bit different than the original request. But yes. This is possible. Are you using Qlik Cloud or On Prem? 

Regards Jandre

[lakshman1031]

Hi Jandrekillian,

I am using Qlik Cloud.

Thanks & Regards,

Lakshman

[lakshman1031]

Hi Jandrekillian,

I am Using Qlik Cloud.

I am trying to using point layer, it is showing points only.

I want to show all points connecting and middle of the area showing Sales data.

Can you please suggest me how to achieve this requirement.

We will use any extension for this requirements, if we required any extension can you please suggest me.

Thanks & Regards,

Lakshman

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[JandreKillianRIC]

Hi @lakshman1031 

Create a account on https://geocode.maps.co/ The free version will let you do 5000 calls per day. 

This is a API for Geocoding - Whether you need a street address from a Lat and Long or the Lat and Long from a street address. I use this quite often, I just tested this using the "forward geocode" API. for the q parameter I enter the Postal Code and the Country - See below 

Now you can loop the this query and get all the Lat / Long you need, Use point and line layers on your maps. 

Regards Jandre