Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

ascioneanna
New 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
Partner
Partner

Re: Map without latitude and longitude params

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
New Contributor III

Re: Map without latitude and longitude params

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?

Highlighted
Partner
Partner

Re: Map without latitude and longitude params

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

rajan_1989
New Contributor III

Re: Map without latitude and longitude params

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
New Contributor III

Re: Map without latitude and longitude params

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?

rajan_1989
New Contributor III

Re: Map without latitude and longitude params

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
New Contributor III

Re: Map without latitude and longitude params

IN qlik Sense? Connection with?

rajan_1989
New Contributor III

Re: Map without latitude and longitude params

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
New Contributor III

Re: Map without latitude and longitude params

How do i create geoanalytics connection?

How of this? Which parametres for geoanalytics connection?

Immagine1.pngImmagine2.png