Write Number in numeric form in Input box like 10, it will print Ten in text object

[srishsum2017]

Hi everyone i have a problem Write Number in numeric form in Input box like 10, it will print Ten in text object...without using of macro please help.

[prma7799]

Like this ? or please share expected output.

[balar025]

Hi Sumit,

here is solution for your query.

Translation from Numbers in Words

Regards,

Ravi

[srishsum2017]

No actually i wnat output like if i write in input box 16 then it will print on text object like sixteen

[prma7799]

Hi Sumit,

It will help you please check

Number to Text? | Qlik Community

how to convert number into words

[tresesco]

You can create number words in the back-end using solution provided by marcus_sommer‌ here Translation from Numbers in Words and then use front-end expression like:

[srishsum2017]

Its correct but when i put 100000 then it gives null value in text object so please dont do the hard code, please give me the dynamic solution

[marcus_sommer]

For me it worked with = only({< Number = {$(vInput)}>} NumbersInWordsRawFormat):

Could it be that there was any selection which excluded your variable-value? It could be also handled within the expression by using 1 as set identifier like: = only({1< Number = {$(vInput)}>} NumbersInWordsRawFormat)

- Marcus

[tresesco]

It's not static at all. You have to just understand the logic. I have just reloaded the application with reduced number. You can set your maximum number in the script (at autogenerate). Set it and reload the application then try, it should work fine.