Number to Text?

[prajapatiamar38]

Hi Community,

I have a scenario I have a field called Numbers in that values are 1,2,3,4........ up to 1000.Now i want when i click any number it will display the text of that number in text object.

For Example: If i select 50 it should display "Fifty",

                     if i select 552 it will display "Five Hundred Fifty two" ..........like that for all numbers.

How can i do this........

Plz suggest

Thanks and Regards

Amarnath

[gautik92]

May be something lik this

[amit_saini]

Amarnath,

Check:

https://community.qlik.com/message/525717#525717

Thanks,
AS

[prajapatiamar38]

Yes Like that but i cant make excel of thousands records any other solution?

[gautik92]

look at this

[sasiparupudi1]

use excel macro that converts your number into words and then upload into qlik

[sasiparupudi1]

check

https://support.microsoft.com/en-us/kb/213360

[prajapatiamar38]

Hi

I have written that code in the excel macro after that how can i upload  in  qlikview

plz tell..

Thanks

[prajapatiamar38]

After running the code dont know what to do...?

Plz suggest

[gautik92]

check my attachment it will help you