topic Re: Convert values to words in QlikView https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908160#M315390 <HTML><HEAD></HEAD><BODY><P>Thanks tresesco how do you added macro </P></BODY></HTML> Tue, 21 Jul 2015 12:40:41 GMT sunilkumarqv 2015-07-21T12:40:41Z Convert values to words https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908156#M315386 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>How to convert the numbers to values for i have values like 1 to 10000</P><P></P><P>Example </P><P>1 - one </P><P>100 - hundred</P><P>122- one twenty two </P><P>200 - two hundred and so on simultaneously&nbsp;&nbsp; </P></BODY></HTML> Tue, 21 Jul 2015 11:26:21 GMT https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908156#M315386 sunilkumarqv 2015-07-21T11:26:21Z Re: Convert values to words https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908157#M315387 <HTML><HEAD></HEAD><BODY><P>Write a function in edit module and call that in the script. You would get vbscript function here: <A href="https://support.microsoft.com/en-us/kb/213360#/en-us/kb/213360" title="https://support.microsoft.com/en-us/kb/213360#/en-us/kb/213360">https://support.microsoft.com/en-us/kb/213360#/en-us/kb/213360</A></P></BODY></HTML> Tue, 21 Jul 2015 11:30:48 GMT https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908157#M315387 tresB 2015-07-21T11:30:48Z Re: Convert values to words https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908158#M315388 <HTML><HEAD></HEAD><BODY><P>Hi tresesco </P><P>its really difficult to understand&nbsp; can you tell me how can we call that in&nbsp; script even there was some error in macro</P></BODY></HTML> Tue, 21 Jul 2015 11:35:39 GMT https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908158#M315388 sunilkumarqv 2015-07-21T11:35:39Z Re: Convert values to words https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908159#M315389 <HTML><HEAD></HEAD><BODY><P>Check the sample attached. You might have to adjust the vbscript a bit according to your need.</P></BODY></HTML> Tue, 21 Jul 2015 12:13:02 GMT https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908159#M315389 tresB 2015-07-21T12:13:02Z Re: Convert values to words https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908160#M315390 <HTML><HEAD></HEAD><BODY><P>Thanks tresesco how do you added macro </P></BODY></HTML> Tue, 21 Jul 2015 12:40:41 GMT https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908160#M315390 sunilkumarqv 2015-07-21T12:40:41Z Re: Convert values to words https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908161#M315391 <HTML><HEAD></HEAD><BODY><P>Open qv app, press Ctrl+M - an editor will open up; paste the vbscript there.</P></BODY></HTML> Tue, 21 Jul 2015 12:53:19 GMT https://community.qlik.com/t5/QlikView/Convert-values-to-words/m-p/908161#M315391 tresB 2015-07-21T12:53:19Z