topic Re: Number to Text? in QlikView https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010130#M342846 <HTML><HEAD></HEAD><BODY><P>Amarnath,</P><P></P><P>Check:</P><P><A _jive_internal="true" href="https://community.qlik.com/message/525717#525717" title="https://community.qlik.com/message/525717#525717">https://community.qlik.com/message/525717#525717</A></P><P></P><P>Thanks,<BR />AS</P></BODY></HTML> Thu, 10 Sep 2015 06:54:13 GMT amit_saini 2015-09-10T06:54:13Z Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010128#M342844 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have a scenario I have a field called Numbers in that values are 1,2,3,4........ up to 1000.Now i want when i click any number it will display the text of that number in text object.</P><P></P><P>For Example: If i select 50 it should display "Fifty",</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if i select 552 it will display "Five Hundred Fifty two" ..........like that for all numbers.</P><P></P><P>How can i do this........</P><P>Plz suggest</P><P></P><P>Thanks and Regards</P><P>Amarnath </P></BODY></HTML> Thu, 10 Sep 2015 06:34:56 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010128#M342844 prajapatiamar38 2015-09-10T06:34:56Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010129#M342845 <HTML><HEAD></HEAD><BODY><P>May be something lik this</P></BODY></HTML> Thu, 10 Sep 2015 06:43:50 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010129#M342845 gautik92 2015-09-10T06:43:50Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010130#M342846 <HTML><HEAD></HEAD><BODY><P>Amarnath,</P><P></P><P>Check:</P><P><A _jive_internal="true" href="https://community.qlik.com/message/525717#525717" title="https://community.qlik.com/message/525717#525717">https://community.qlik.com/message/525717#525717</A></P><P></P><P>Thanks,<BR />AS</P></BODY></HTML> Thu, 10 Sep 2015 06:54:13 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010130#M342846 amit_saini 2015-09-10T06:54:13Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010131#M342847 <HTML><HEAD></HEAD><BODY><P>Yes Like that but i cant make excel of thousands records any other solution?</P></BODY></HTML> Thu, 10 Sep 2015 07:00:08 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010131#M342847 prajapatiamar38 2015-09-10T07:00:08Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010132#M342848 <HTML><HEAD></HEAD><BODY><P>look at this</P></BODY></HTML> Thu, 10 Sep 2015 07:35:01 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010132#M342848 gautik92 2015-09-10T07:35:01Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010133#M342849 <HTML><HEAD></HEAD><BODY><P>use excel macro that converts your number into words and then upload into qlik</P></BODY></HTML> Thu, 10 Sep 2015 07:48:56 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010133#M342849 sasiparupudi1 2015-09-10T07:48:56Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010134#M342850 <HTML><HEAD></HEAD><BODY><P>check</P><P><A href="https://support.microsoft.com/en-us/kb/213360" title="https://support.microsoft.com/en-us/kb/213360">https://support.microsoft.com/en-us/kb/213360</A></P></BODY></HTML> Thu, 10 Sep 2015 07:49:10 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010134#M342850 sasiparupudi1 2015-09-10T07:49:10Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010135#M342851 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have written that code in the excel macro after that how can i upload&nbsp; in&nbsp; qlikview </P><P>plz tell..</P><P></P><P>Thanks</P></BODY></HTML> Thu, 10 Sep 2015 08:55:36 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010135#M342851 prajapatiamar38 2015-09-10T08:55:36Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010136#M342852 <HTML><HEAD></HEAD><BODY><P>After running the code dont know what to do...?</P><P></P><P>Plz suggest</P></BODY></HTML> Thu, 10 Sep 2015 08:58:29 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010136#M342852 prajapatiamar38 2015-09-10T08:58:29Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010137#M342853 <HTML><HEAD></HEAD><BODY><P>check my attachment it will help you</P></BODY></HTML> Thu, 10 Sep 2015 08:58:55 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010137#M342853 gautik92 2015-09-10T08:58:55Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010138#M342854 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I want without writing the text for each number.</P></BODY></HTML> Thu, 10 Sep 2015 09:15:32 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010138#M342854 prajapatiamar38 2015-09-10T09:15:32Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010139#M342855 <HTML><HEAD></HEAD><BODY><P>i have attached excel for that did you check that?</P></BODY></HTML> Thu, 10 Sep 2015 09:17:01 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010139#M342855 gautik92 2015-09-10T09:17:01Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010140#M342856 <HTML><HEAD></HEAD><BODY><P>I would generate the maximum possible numbers and their corresponding words in the excel(2 columns)</P><P></P><P>load in to qv as a mapping load</P><P></P><P>use applymap on the number column in your target table to get the words</P><P></P><P>hth</P><P>Sasi</P></BODY></HTML> Thu, 10 Sep 2015 09:23:42 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010140#M342856 sasiparupudi1 2015-09-10T09:23:42Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010141#M342857 <HTML><HEAD></HEAD><BODY><P>Can you share one sample application.</P></BODY></HTML> Thu, 10 Sep 2015 10:35:52 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010141#M342857 prajapatiamar38 2015-09-10T10:35:52Z Re: Number to Text? https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010142#M342858 <HTML><HEAD></HEAD><BODY><P>Have a look at this </P></BODY></HTML> Thu, 10 Sep 2015 10:37:25 GMT https://community.qlik.com/t5/QlikView/Number-to-Text/m-p/1010142#M342858 gautik92 2015-09-10T10:37:25Z