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

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

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

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.

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

prma7799 — Wed, 09 Aug 2017 04:52:08 GMT

Like this ? or please share expected output.

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

balar025 — Wed, 09 Aug 2017 04:59:46 GMT

Hi Sumit,

here is solution for your query.

Translation from Numbers in Words

Regards,

Ravi

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

srishsum2017 — Wed, 09 Aug 2017 05:31:54 GMT

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

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

prma7799 — Wed, 09 Aug 2017 05:40:23 GMT

Hi Sumit,

It will help you please check

Number to Text? | Qlik Community

how to convert number into words

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

tresB — Wed, 09 Aug 2017 05:45:08 GMT

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:

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

srishsum2017 — Wed, 09 Aug 2017 08:20:53 GMT

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

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

marcus_sommer — Wed, 09 Aug 2017 08:32:58 GMT

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

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

tresB — Wed, 09 Aug 2017 09:05:02 GMT

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.