topic Re: How to convert Amount in words in App Development

How to convert Amount in words

Karthick30 — Tue, 01 Mar 2022 17:07:41 GMT

Hi,

I have a value as Amount. ( like $99 ) . I need to convert this as Dollar Ninety Nine.

Any way to achieve this?

Re: How to convert Amount in words

SBDataspark — Tue, 01 Mar 2022 19:25:04 GMT

Hi Karthick30,

I haven't checked if this works, but this blogpost suggests a solution:

Translation from Numbers in Words - Qlik Community - 1494628

Kind regards,

Sebb

Re: How to convert Amount in words

Andrea_Spinetti — Wed, 02 Mar 2022 15:47:10 GMT

Hi @Karthick30, what has been shared by @SBDataspark is a great example that shows a pretty fast way to translate Numbers under 1Mln into Words. I would add that in your case you may need to add also a table for the currencies, using the same logic as for the numbers.

Re: How to convert Amount in words

Karthick30 — Mon, 07 Mar 2022 13:00:05 GMT

Hi @Andrea_Spinetti @SBDataspark ,

As mentioned, its not working for above 1 mln. Do you have any URL's or cases where we can use more than 1 million amount in to words?

Any help is appreciated

Re: How to convert Amount in words

SBDataspark — Mon, 07 Mar 2022 13:11:12 GMT

Hi @Karthick30,

The blog post is what I found when searching the community.
That's all I can contribute right now.

Maybe someone else can give you any additional information.

Kind regards,

Sebb