topic Re: number to text in QlikView

number to text

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a data in excel with the column name

Number

so I want to load this in qlik result as

1 --one

2 -- two

3 -- three

----- like so on..

Re: number to text

Kushal_Chawda — Wed, 13 Sep 2017 07:45:11 GMT

see this

convert number to text

Re: number to text

tresB — Wed, 13 Sep 2017 07:45:53 GMT

Check these:

Translation from Numbers in Words

Re: number to text

its_anandrjs — Wed, 13 Sep 2017 08:10:41 GMT

Here you have to do the Mapping Load is best option

MapTab:

Mapping Load * inline

[

Number,NumToText

1,one

2,two

3, three

];

Load *,applymap('MapTab',Number,'None')

Load * inline

[

Number

];

Re: number to text

soniasweety — Wed, 13 Sep 2017 09:02:51 GMT

thanks all. good example anand

Re: number to text

Kushal_Chawda — Wed, 13 Sep 2017 09:05:55 GMT

If you have fixed numbers then you can go with approach suggested by the Anand, but if your numbers are dynamic then you need to go with different approach suggested by me & Tresesco

Re: number to text

its_anandrjs — Wed, 13 Sep 2017 09:18:37 GMT

Thanks If you have more numbers like in 1000+ then go with Marcus Suggestion.

Translation from Numbers in Words

Re: number to text

soniasweety — Wed, 13 Sep 2017 09:26:05 GMT

its fixed numbers I have only 15 in my excel. thanks for the explanation

Re: number to text

soniasweety — Wed, 13 Sep 2017 09:26:27 GMT

Okay anand thanks.