Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Venthan
Contributor III
Contributor III

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
premvihari
Partner
Partner

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);