Qlik Sense Map Geo Points

[dberkesacn]

Hi,

I have seen this video Qlik Sense 3.1 - Understanding Geographic Data Profiling - YouTube from @Michael Tarallo

It says that Sense automatically generates geo points. I have tried this function with my Sense Desktop (3.1 SR6 latest version), but I haven't found any geo points after the data loading process.

My data is the following read from xlsx:

Country	Sales
French	100
Italy	150
Spain	200

qvf is attached.

thanks,

Daniel

[dberkesacn]

Thanks,

appreciate your help, but the main point here for me was QlikSense can 'translate' country code for example Hungary to geopoints and draw maps, without any function and data modification.

In Tableau you can do it....

[lironbaram]

hi

Data profiling only happen of you load the data using the data manager

not if you load via the script editor

hope that helps

[kvanandan1]

At present , there is no function required in Qliksense for rendering a map, it requires an additional field country code. May be Qlik can come out with a similar feature available with other vendors in future.

thanks.

[dberkesacn]

Tried with Country Code + ISO3 but it doesn't work

[dberkesacn · Accepted solution]

Ok, it seems that I solved my question after 2 days.

So if you click on prepare data during the load it'll works just based on COUNTRY NAME but if you click on that screen load and finish or directly load your xls it wont work.

Here you have to click on Prepare data.

You can see the geo icon below Sheet1 icon, and the fact that only two column were loaded Country name and sales.

[kvanandan1]

Are you trying with data manager or data load editor.

It is working with data manager, i am using version 3.2 SR4.

[dberkesacn]

figured out, it works only if you click on prepare data.

[OmarBenSalem]

I already told you that; you weren't keeping attention

[dberkesacn]

Sorry indeed, that time I didn't know that features is exists, because I have loaded data with different methods. plus sometimes I ignore words written in all caps since it seems shouting...

Thank you Omar.

[dberkesacn]

Another question,

Now Sense did recognize the geo points but 'just' for Shapes not points, I can not use expression like sum sales and get dots in the map chart, just color as expression...

Is it possible to do it somehow?

D