topic Re: Convert Number to Text in QlikView

Convert Number to Text

bharatkishore — Wed, 24 Apr 2019 09:59:52 GMT

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

Anil_Babu_Samineni — Wed, 24 Apr 2019 10:06:52 GMT

Perhaps this?

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

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

bharatkishore — Wed, 24 Apr 2019 10:11:22 GMT

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