Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Display country name based on Country code

Hi All,

I have a source table which contains only the standard country code, but I want to display the corresponding country name in my straight table.

Is there any mapping available in Qliksense for this?

1 Reply
Highlighted
Partner
Partner

Re: Display country name based on Country code

Hi ,

By deafult qliksense comes with countryAliases and Country Geo QVD files

you can try below

__countryAliasesBase:
LOAD
Alias AS [__Country],
ISO3Code AS [__ISO3Code]
FROM [lib://AttachedFiles/countryAliases.qvd]
(qvd);

__countryGeoBase:
LOAD
ISO3Code AS [__ISO3Code],
ISO2Code AS [__ISO2Code],
Polygon AS [__Polygon]
FROM [lib://AttachedFiles/countryGeo.qvd]
(qvd);