Display country name based on Country code

[Venthan]

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?

[premvihari]

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