topic Number formatting.... in QlikView https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661918#M1078074 <HTML><HEAD></HEAD><BODY><P>Hi All, I have a set of code that I would like to set the number format after an equation. Does anyone know how to do this?&nbsp; format would be '(#,#00)'</P><P></P><P>='CPM: ' &amp;<SPAN style="color: #0000ff;">sum</SPAN>({&lt;<SPAN style="color: #800000;">[Supplier.No_Approved Parts]</SPAN> = {'&gt;=1'},</P><P></P><P><SPAN style="color: #800000;">[NCMR.Type]</SPAN> = {'Vendor'},</P><P></P><P><SPAN style="color: #800000;">NCMR.SITE</SPAN> = {'TJM', 'VST'}&gt;} <SPAN style="color: #800000;">[NCMR.SUSPECT_QUANTITY]</SPAN>) / </P><P></P><P><SPAN style="color: #0000ff;">Sum</SPAN>({&lt;<SPAN style="color: #800000;">NCMR.SITE</SPAN> = {'TJM', 'VST'}&gt;} <SPAN style="color: #800000;">[Supplier.No_Approved Parts]</SPAN>) *1000000 </P><P> </P></BODY></HTML> Fri, 11 Jul 2014 18:24:14 GMT leocattqv 2014-07-11T18:24:14Z Number formatting.... https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661918#M1078074 <HTML><HEAD></HEAD><BODY><P>Hi All, I have a set of code that I would like to set the number format after an equation. Does anyone know how to do this?&nbsp; format would be '(#,#00)'</P><P></P><P>='CPM: ' &amp;<SPAN style="color: #0000ff;">sum</SPAN>({&lt;<SPAN style="color: #800000;">[Supplier.No_Approved Parts]</SPAN> = {'&gt;=1'},</P><P></P><P><SPAN style="color: #800000;">[NCMR.Type]</SPAN> = {'Vendor'},</P><P></P><P><SPAN style="color: #800000;">NCMR.SITE</SPAN> = {'TJM', 'VST'}&gt;} <SPAN style="color: #800000;">[NCMR.SUSPECT_QUANTITY]</SPAN>) / </P><P></P><P><SPAN style="color: #0000ff;">Sum</SPAN>({&lt;<SPAN style="color: #800000;">NCMR.SITE</SPAN> = {'TJM', 'VST'}&gt;} <SPAN style="color: #800000;">[Supplier.No_Approved Parts]</SPAN>) *1000000 </P><P> </P></BODY></HTML> Fri, 11 Jul 2014 18:24:14 GMT https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661918#M1078074 leocattqv 2014-07-11T18:24:14Z Re: Number formatting.... https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661919#M1078075 <HTML><HEAD></HEAD><BODY><P>use the num function:</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">='CPM: ' &amp; <STRONG>num(</STRONG><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #0000ff;">sum</SPAN>({&lt;<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">[Supplier.No_Approved Parts]</SPAN> = {'&gt;=1'},</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">[NCMR.Type]</SPAN> = {'Vendor'},</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">NCMR.SITE</SPAN> = {'TJM', 'VST'}&gt;} <SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">[NCMR.SUSPECT_QUANTITY]</SPAN>) /</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #0000ff;">Sum</SPAN>({&lt;<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">NCMR.SITE</SPAN> = {'TJM', 'VST'}&gt;} <SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">[Supplier.No_Approved Parts]</SPAN>) *1000000<STRONG>, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">'(#,#00)'</SPAN>)</STRONG></P></BODY></HTML> Fri, 11 Jul 2014 18:27:12 GMT https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661919#M1078075 jerem1234 2014-07-11T18:27:12Z Re: Number formatting.... https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661920#M1078076 <HTML><HEAD></HEAD><BODY><P>That Worked, thank you</P></BODY></HTML> Fri, 11 Jul 2014 18:31:16 GMT https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661920#M1078076 leocattqv 2014-07-11T18:31:16Z Re: Number formatting.... https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661921#M1078077 <HTML><HEAD></HEAD><BODY><P>Not cool Leo, not cool...</P></BODY></HTML> Fri, 11 Jul 2014 18:40:19 GMT https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661921#M1078077 2014-07-11T18:40:19Z Re: Number formatting.... https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661922#M1078078 <HTML><HEAD></HEAD><BODY><P>You're welcome! Please mark any answers that were helpful or correct...</P></BODY></HTML> Fri, 11 Jul 2014 18:40:57 GMT https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661922#M1078078 jerem1234 2014-07-11T18:40:57Z Re: Number formatting.... https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661923#M1078079 <HTML><HEAD></HEAD><BODY><P>ummmm, whats not cool?</P></BODY></HTML> Fri, 11 Jul 2014 18:53:19 GMT https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661923#M1078079 leocattqv 2014-07-11T18:53:19Z Re: Number formatting.... https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661924#M1078080 <HTML><HEAD></HEAD><BODY><P>I believe Jeremiah provided you with the correct answer, my fair man.&nbsp; In situations like this here in our Qlik Community that would be an appropriate time to provide the person who provided you with the correct answer the points for said correct answer.&nbsp; It is, as Jacob said "not cool" to give this accolade to yourself when a hard working young man worked his fingers to the bone trying to assist you.</P></BODY></HTML> Mon, 14 Jul 2014 12:21:48 GMT https://community.qlik.com/t5/QlikView/Number-formatting/m-p/661924#M1078080 2014-07-14T12:21:48Z