Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Convert Number to Text

Hi All,

I have a field in that i have numbers like 1704,1705.. etc.

Now  i need to get names instead of numbers.

For e.g. 1704 should be Germany.

I have written if(Match(field,'1704','Germany'),Field).

But this is expression is not working and getting number only.

Can you please tell me how to achieve this.

Thanks,

Bharat

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Perhaps this?

if(Match(field,'1704'),'Germany',Field)

Or

Pick(Match(field,'1704','1705'), 'Germany', 'India').

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Anil_Babu_Samineni

Perhaps this?

if(Match(field,'1704'),'Germany',Field)

Or

Pick(Match(field,'1704','1705'), 'Germany', 'India').

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

bharatkishore
Creator III
Creator III
Author

Thank you so slight mistake(brace) in my expression. My bad and thanks a lot..