How to convert Amount in words

[Karthick30]

Hi,

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

Any way to achieve this?

[SBDataspark · Accepted solution]

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

[Andrea_Spinetti]

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.

[Karthick30]

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

[SBDataspark]

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