How make code value as custom name?

[allsolution]

I have many data's like SF, LA, NY etc. How to display them as full San Francisco, Los Angeles,  New York on Qlik sense filter pane chart? Data source is local database.

[ramchalla]

Hi,

Create an excel file with the location and location full name information. Create a mapping load with these 2 fields and use an Applymap to include the location full name in fact table. Later you can start using the location full name field as a filter.

Please find the below code and the attached excel file.

Map_Location:
Mapping
LOAD Location,
[Location Full Name]
FROM
[C:\Users\admin\OneDrive\Desktop\Locations.xlsx]
(ooxml, embedded labels, table is Sheet1);

ApplyMap('Map_Location', Location) as [Location Full Name]

[Chanty4u · Accepted solution]

Try this 

=Pick(Match(CityCode, 'SF', 'LA', 'NY'),

      'San Francisco', 'Los Angeles', 'New York')

[pravinboniface]

@Chanty4u What is the difference between first and second option?