Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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  

Labels (1)
1 Solution

Accepted Solutions
tresB
Champion III
Champion III

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

View solution in original post

5 Replies
tresB
Champion III
Champion III

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

tresB
Champion III
Champion III

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

tresB
Champion III
Champion III

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