topic Spell Number in QlikView

Spell Number

Sokkorn — Mon, 30 Apr 2012 09:15:32 GMT

Hi All,

Let say I have number $110.00 then I need to spell it into <One Hundred Ten US Dollars and Zero Cents>.

How can I achive this?

Regards,

Sokkorn

Spell Number

haymarketpaul — Mon, 30 Apr 2012 10:23:28 GMT

Depending upon where your data is coming from?

The excellent ASAP Utilities addin for Excel has this function built into it.

Spell Number

flipside — Mon, 30 Apr 2012 10:42:01 GMT

To do this within QV itself, to get you started, take this script from here ...

http://www.ozgrid.com/VBA/ValueToWords.htm

... and paste it into the module. You may need to tidy it up a bit to get the module to recognise it (some blank lines need removing) and also some datatype assignments (As String commands).

Set up a test routine like this ...

sub SpellOut

MsgBox SpellNumber(1523)

end sub

... and test it. It will throw some errors (it doesn't recognise the function Val for instance) so just delete the word.

flipside

Re: Spell Number

rmuhammad — Thu, 26 Nov 2015 21:38:14 GMT

Finally I was able to turn this logic into QV VBA script. Please see attached functional example.

Re: Spell Number

vikasmahajan — Fri, 27 Nov 2015 04:37:26 GMT

Good Work Rashid !!!

Thanks for Sharing

Vikas