topic Text Object Number Formating in QlikView https://community.qlik.com/t5/QlikView/Text-Object-Number-Formating/m-p/783338#M277325 <HTML><HEAD></HEAD><BODY><P>I am trying to format the following expression:</P><P>=Count(Distinct [Script Number] ) whose value is 26186 to be 26,186 and i am getting errors.&nbsp; How can i accomplish this.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 19 Nov 2014 21:29:26 GMT Anonymous 2014-11-19T21:29:26Z Text Object Number Formating https://community.qlik.com/t5/QlikView/Text-Object-Number-Formating/m-p/783338#M277325 <HTML><HEAD></HEAD><BODY><P>I am trying to format the following expression:</P><P>=Count(Distinct [Script Number] ) whose value is 26186 to be 26,186 and i am getting errors.&nbsp; How can i accomplish this.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 19 Nov 2014 21:29:26 GMT https://community.qlik.com/t5/QlikView/Text-Object-Number-Formating/m-p/783338#M277325 Anonymous 2014-11-19T21:29:26Z Re: Text Object Number Formating https://community.qlik.com/t5/QlikView/Text-Object-Number-Formating/m-p/783339#M277326 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Does this work ?&nbsp; <BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">num( Count(Distinct [Script Number] ), '#,###') </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">or</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">num( Count(Distinct [Script Number] ), '#,##0') </SPAN></P></BODY></HTML> Wed, 19 Nov 2014 21:44:40 GMT https://community.qlik.com/t5/QlikView/Text-Object-Number-Formating/m-p/783339#M277326 JonnyPoole 2014-11-19T21:44:40Z Re: Text Object Number Formating https://community.qlik.com/t5/QlikView/Text-Object-Number-Formating/m-p/783340#M277327 <HTML><HEAD></HEAD><BODY><P>Many thanks, the trick was on the "Num"</P><P></P><P>Regards.</P></BODY></HTML> Wed, 19 Nov 2014 21:47:58 GMT https://community.qlik.com/t5/QlikView/Text-Object-Number-Formating/m-p/783340#M277327 Anonymous 2014-11-19T21:47:58Z