topic Re: Problem with mapping and geo location in App Development

Problem with mapping and geo location

Nemo1 — Tue, 30 Jan 2024 09:36:58 GMT

Hello everyone,

I am trying to add a map to my analysis. The problem is, that for the cities I only have the abbreviation, and the map is taking the wrongly. I tried in many ways to add an if column to match the abbreviations to the cities but for one reason or another, it is not taking me anywhere.

A mapping table was use which looks like: (is written in a mapping section)

Map_Company:
Mapping
LOAD
Client,
Company
FROM [lib://daten/01 Food/Version_5/20200429.xlsx]
(ooxml, embedded labels, table is Company);

Then I have another section for the principal data, and the Company is loaded like this:

Data_022:
LOAD
applymap ('Map_Company', Client) as Company,

"Company" ends up showing me the abbreviations for the cities, now what I want to do is to link this abbreviations to the respective cities. How can I do that?

thanks!!!

Re: Problem with mapping and geo location

LRuCelver — Tue, 30 Jan 2024 12:33:38 GMT

Just for clarification:

The field "Company" is supposed to show the abbreviations of the cities?
You tried to display the cities on a map but they display in the wrong locations?
You are trying to fix this by 'linking' the abbreviations to the full city names?

If you have access to the Qlik GeoAnalytics Connection, you can load a table with all recognized city codes/names and try to create a manual mapping from the abbreviations.
If you have a standardized abbreviation/code (e.g. UN/LOCODE) there is a high chance Qlik Sense will display the city correctly with just the code.

Re: Problem with mapping and geo location

Nemo1 — Tue, 30 Jan 2024 12:36:43 GMT

Hello, thanks for your answer.

1- Yes, Company shows the abbreviations of the cities.

2- Exactly, they were showing random locations

3- Exactly, that was my plan.

I did not know that something like GeoAnalytics Connection existed. Where can I get these access?

thanks!

Re: Problem with mapping and geo location

LRuCelver — Tue, 30 Jan 2024 13:08:38 GMT

More info regarding Qlik GeoAnalytics: Qlik GeoAnalytics Connector | Qlik GeoAnalytics Help

If you mapped the abbreviations to something the Qlik Sense map recognizes, you can display it on the map. You might have to manually adjust the scope to e.g. only look for cities.

Here is a quick example of me mapping the license plate codes for Hamburg, Bremen, Berlin, Munich and Stuttgart to their respective UN/LOCODE and showing them on a map. I didn't have to adjust the scope, but it may help with your application:

Map_Plate_Locode: Mapping Load * Inline [ PlateAbb, UNLOCODE HH, DEHAM HB, DEBRE B, DEBER M, DEMUC S, DESTR ]; Data: Load ApplyMap('Map_Plate_Locode', Abbreviation) as Locode Inline [ Abbreviation HH HB B M S ];

Re: Problem with mapping and geo location

Nemo1 — Fri, 02 Feb 2024 07:18:18 GMT

Great, thanks!!!