Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sunilkumarqv
Specialist II
Specialist II

Convert values to words

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  

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

View solution in original post

5 Replies
tresesco
MVP
MVP

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
Specialist II
Specialist II
Author

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
MVP
MVP

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

sunilkumarqv
Specialist II
Specialist II
Author

Thanks tresesco how do you added macro

tresesco
MVP
MVP

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