Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
ascioneanna
Contributor III
Contributor III

Map without latitude and longitude params

Hi,

I need to create a QlikSENSE Map. I don't have any information about latitude and longitude.

I have Only Posta Code.

Someone has any idea about this?

I attached app.

Thanks Anna

11 Replies
slondono
Partner - Creator II
Partner - Creator II

I think the only way is using QlikGeoAnalytics. With Geo you can create maps without Points, using only City names, postal codes, and country names.

Other option is that you ccan search the (Latitude, Longitude) for each city and paste it as a field. Then you will create maps without GeoAnalytics.

Here you can find the latitude and longitude for italy cities.

Italy latitude and longitude

ascioneanna
Contributor III
Contributor III
Author

OK, thank you. In my app i use this tag but not enough.

TAG FIELDS CAP WITH $geomultipolygon;

In your opinion i have to use REST Connector with Google Analytics?

slondono
Partner - Creator II
Partner - Creator II

For the map thing i think you dont need to use REST. But im not sure what you want

Anonymous
Not applicable

Hi Anna,

I am guessing you are looking for indian postal code points.

you can get the pincodes from government websites and load it into a table in qlikview.

Use the named point lookup and use the pincode field to get lat-longs for each pincode.

then you can plot them easily on the map.

Hope this helps.

ascioneanna
Contributor III
Contributor III
Author

Hi Rajan,  i am looking italian postal code points. I can't find it.

I don't know how to do a map fpr this analysis.

Can you help me?

Anonymous
Not applicable

Hi Anna,

create a new qvw file and use the load operation to load all the zipcode points of italy.

the following script should be generated

SQL SELECT * FROM Load(dataset='Dataset')

DATASOURCE Dataset LOCATIONSERVICE geometry='POINT',type='XPC',country='IT',serviceName='default'.

in simlar way you can find out yourself for other countries, wether they have lat longs for that specific country's zip code.

attaching the output of the above operation here

ascioneanna
Contributor III
Contributor III
Author

IN qlik Sense? Connection with?

Anonymous
Not applicable

works with borth Qlik sense and Qlik view.

in your script editor you can see a geo analytics connector. Use that connector to insert connection string and select data using that connector - select load operation and then fill in the parameters as shown in the above query.

press ok and a script will be generated as I mentioned in my previous reply.

ascioneanna
Contributor III
Contributor III
Author

How do i create geoanalytics connection?

How of this? Which parametres for geoanalytics connection?

Immagine1.pngImmagine2.png