Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
lavrendis
New Contributor

Map feature question

Hello,

After some time of trouble i have managed to load a KML file because i have seen that my map when i used the auto feature from Qliksense was missing several countries.

Now, i have another issue. My country names are in french and my KML file has the ISO2 code.

In order to link this i have come to the conclusion that i need to use almost 200 if statements to modify the french country names to the ISO2 code during  the script load.

I mean statements like this: if([COUNTRYREGIONID]= 'France', 'FR', [COUNTRYREGIONID] ) as [COUNTRYREGIONID],

This means that it is a crazy work to do and also that my script load will be too long.

Is there any other fastest way to perform this?

Best regards,

Lawrence

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Map feature question

Hi Lawrence,

you can solve this problem in a lot more elegant way, using a MAPPING table. Create an Excel table with 200 countries and 200 pairs of values - the French country name and the ISO2 code.

Then, load the Excel Table using a MAPPING load:

Country_Map:

MAPPING LOAD

     Country,

     ISO2

FROM ...

;

Then, apply the map in the table where you have your French country names:

LOAD

  ...

  Country,

  ApplyMap('Country_Map', Country, 'N/A') as ISO2,

...

You can read more about MAPPING in the Help Section.

Cheers,

Oleg Troyansky

Upgrade your Qlik skills with my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense

2 Replies
MVP & Luminary
MVP & Luminary

Re: Map feature question

Hi Lawrence,

you can solve this problem in a lot more elegant way, using a MAPPING table. Create an Excel table with 200 countries and 200 pairs of values - the French country name and the ISO2 code.

Then, load the Excel Table using a MAPPING load:

Country_Map:

MAPPING LOAD

     Country,

     ISO2

FROM ...

;

Then, apply the map in the table where you have your French country names:

LOAD

  ...

  Country,

  ApplyMap('Country_Map', Country, 'N/A') as ISO2,

...

You can read more about MAPPING in the Help Section.

Cheers,

Oleg Troyansky

Upgrade your Qlik skills with my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense

rivenbryan
New Contributor

Re: Map feature question

Hi, do you mind to elaborate? 

 

FROM .. what should i put insde? Sorry i am very new to Qliksense Programming Syntax.

Community Browser