topic Re: Qlik Sense Map Creation in Visualization and Usability

Qlik Sense Map Creation

rajarshi_guin — Fri, 02 Feb 2018 07:37:02 GMT

Hi All,

I have a file which contains the US State names along with various other measures columns. I want to display the States in a map. I am able to create a map by storing latitude and longitude information of all the states in another file and then importing that file into Qlik Sense.

However, my query is can we create a map without separately importing the longitude and latitude information from another file. Is Qlik Sense able to create a map if we have only the State names in a file without longitude and latitude information? If yes. can anyone please let me know how to do that.

Thanks and Regards,

Rajarshi Guin

Re: Qlik Sense Map Creation

YoussefBelloum — Fri, 02 Feb 2018 08:26:41 GMT

Hi,

If you load the table which contains the Departments column with the DATA MANAGER, Qliksense will try to recognize geographical informations for you and creates a geographical field, But I'm not sure that it can recognize departments, it worked for me with country field for example.

Otherwise, use your latitude and longitude informations with GeoMakePoints() to be able to display them on a map.

Re: Qlik Sense Map Creation

consultant_bi — Fri, 02 Feb 2018 09:15:27 GMT

Hello,

in my experience when you load a table wich contains cities or states or countries, in the map Qlik Sense gonna recognize but not allow to display as points but it gonna fill all the country for example the value Paris it gonna fill all the France but if you had fields with Longitude and Latitude it gonna just point the city Paris.

and May be i am wrong, wait for our experienced friends answers.

P.S: i was wrong it's possible for cities read below but states no points able just polygone and it's logical

Re: Qlik Sense Map Creation

OmarBenSalem — Fri, 02 Feb 2018 09:16:31 GMT

To be able to use Your states in a Map chart; you have to tell QLIK to help you with that.

Now, with that being said; there is 2 ways of loading data :

1) through the script : We have the full control

2) through the data load editor : Where QLIK SENSE try to assist/help us

So, with that being said; what yoiu should is go to the data load editor ;

synchronise the table of the script:

and than reload data.

With that, Qlik SENSE will recognize your states as GeoFields and thus you can use them directly in a map chart without lat/lon combinations.

Re: Qlik Sense Map Creation

OmarBenSalem — Fri, 02 Feb 2018 09:17:53 GMT

As far as I've seen; Qlik Sense (through data load editor) recognizes cities as points and countries as polygonnes

Re: Qlik Sense Map Creation

YoussefBelloum — Fri, 02 Feb 2018 09:23:44 GMT

Hi omarbensalem‌ what do you mean by "tell Qlik to help him with that " ?

Re: Qlik Sense Map Creation

OmarBenSalem — Fri, 02 Feb 2018 09:32:14 GMT

Youssef,

There is 2 ways to load your data in QLIK SENSE

1) script: Qlik does not assist with this; we have full control over everything

2)Data load editor: QLik Sense assist us with this; recognizes GeoFields, Date field, creates auto calendar, time measures (YTD and so on), helps with the table associations , proposes recommandations, concatenations, crossing tables, data fractionning and so on..

So, to be able to use the City Names in a Map object without loading their Lat/Lon, we have to tell QLIK to HELP us with that => Synchronise our table through the data load editor and reload.

And only with this, Qlik will recognize our city names as GeoFields (only by their name, no need to lat/lon) and thus we'll be able to use them in a chart Map.

ps: I was trying to explain this approach rather then telling him directly what to do

Re: Qlik Sense Map Creation

consultant_bi — Fri, 02 Feb 2018 09:39:39 GMT

Hello again,

Well as Omar said it worked you have just to write the name of cities in correct format to make Qlik Sense recognize the cities

here is an example of data without longitude and latitude information and i made the points on the map

Re: Qlik Sense Map Creation

consultant_bi — Fri, 02 Feb 2018 09:42:20 GMT

Hello Omar i can't use the Synchronise our table , i don't have the hand

Re: Qlik Sense Map Creation

OmarBenSalem — Fri, 02 Feb 2018 09:45:37 GMT

Have you loaded your data directly through the data load editor? Or through the script?

Re: Qlik Sense Map Creation

consultant_bi — Fri, 02 Feb 2018 09:48:09 GMT

hello Omar,

through the data load editor

Re: Qlik Sense Map Creation

OmarBenSalem — Fri, 02 Feb 2018 09:57:08 GMT

So, u don't have anything to synchronize since u've already used the data load editor to load ur table.

Synchronize =

U've loaded ur data through the script; the tables have thus been created in the SCRIPT.

Now, if u want Qlik to help with some things (like recognizing GeoFields in our case)

We want to tranfer our tables from the script to the data load editor (where the recognizition is possible)

=> Synchronize = SYNCHRONIZE table from the script to load editor = qlik sense will synchronise the tables loaded in the script and "transfer" them into its data load editor so that he could have full countrol over ur data and "HELP us".

Hope that was clear?

Re: Qlik Sense Map Creation

consultant_bi — Fri, 02 Feb 2018 10:04:56 GMT

oh okay i got it now , when you load the data through the script to make it editable and helpful with Qlik into the Data Load Editor the Synchronise gonna be able then.

thank you it's clear now.

Re: Qlik Sense Map Creation

YoussefBelloum — Fri, 02 Feb 2018 10:25:36 GMT

I know this, he was talking about States

maybe you mean "ask for an improvment on this feature to let Qliksense recognize more type of Geo informations on the future" like States, Adresses (it is planned for this year) ?

Otherwise, if it is not possible, they can't help him (they will ask him to add KML or LAT/LONG data).

Re: Qlik Sense Map Creation

OmarBenSalem — Fri, 02 Feb 2018 10:32:43 GMT

I think United STATES are recognized; (Washington is a State, New York.. etc)

It's not a department, It's the US State names he's trying to show:

Re: Qlik Sense Map Creation

YoussefBelloum — Fri, 02 Feb 2018 10:52:40 GMT

I read it already Omar,

If I was sure that States are recognized, I would have said that

but if you just think, you can ask an expert like mto‌ to confirm you this info.

and If it is recognized, just verify that states correctly wrote consultant_bi‌

good luck

Re: Qlik Sense Map Creation

consultant_bi — Fri, 02 Feb 2018 11:04:44 GMT

it's working for States too you have just to wright the correct name in correct format

Re: Qlik Sense Map Creation

YoussefBelloum — Fri, 02 Feb 2018 11:07:19 GMT

Very Good, that's what I was talking about