QlikView App Dev

[sunilkumarqv]

Hi all

How to convert the numbers to values for i have values like 1 to 10000

Example

1 - one

100 - hundred

122- one twenty two

200 - two hundred and so on simultaneously  

[tresesco]

Write a function in edit module and call that in the script. You would get vbscript function here: https://support.microsoft.com/en-us/kb/213360#/en-us/kb/213360

[sunilkumarqv]

Hi tresesco

its really difficult to understand  can you tell me how can we call that in  script even there was some error in macro

[tresesco · Accepted solution]

Check the sample attached. You might have to adjust the vbscript a bit according to your need.

[sunilkumarqv]

Thanks tresesco how do you added macro

[tresesco]

Open qv app, press Ctrl+M - an editor will open up; paste the vbscript there.