topic Re: Format Expression in QlikView https://community.qlik.com/t5/QlikView/Format-Expression/m-p/1320583#M409339 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>= 'Quantity Available:&nbsp;&nbsp;&nbsp; '&nbsp;&nbsp;&nbsp;&nbsp; &amp;&nbsp;&nbsp; Num((Sum(vTotalCapacity) - Sum(num_seats)), '#,###.')</STRONG></SPAN></P></BODY></HTML> Tue, 06 Jun 2017 18:54:10 GMT sunny_talwar 2017-06-06T18:54:10Z Format Expression https://community.qlik.com/t5/QlikView/Format-Expression/m-p/1320582#M409338 <HTML><HEAD></HEAD><BODY><P>I have an expression that appears as:</P><P></P><P>= 'Quantity Available:&nbsp;&nbsp;&nbsp; '&nbsp;&nbsp;&nbsp;&nbsp; &amp;&nbsp;&nbsp; NUM(SUM(vTotalCapacity)-(NUM(SUM(num_seats),'#,###.')))</P><P></P><P>vTotalCapacity = 71950</P><P></P><P>I want my expected output to be formatted as ##,###, however I cannot get the expression to have that output, the result is formatted as #####, with no separator as I am attempting to do.</P><P></P><P>Have I structured this equation incorrectly?</P></BODY></HTML> Tue, 06 Jun 2017 18:47:52 GMT https://community.qlik.com/t5/QlikView/Format-Expression/m-p/1320582#M409338 evansabres 2017-06-06T18:47:52Z Re: Format Expression https://community.qlik.com/t5/QlikView/Format-Expression/m-p/1320583#M409339 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>= 'Quantity Available:&nbsp;&nbsp;&nbsp; '&nbsp;&nbsp;&nbsp;&nbsp; &amp;&nbsp;&nbsp; Num((Sum(vTotalCapacity) - Sum(num_seats)), '#,###.')</STRONG></SPAN></P></BODY></HTML> Tue, 06 Jun 2017 18:54:10 GMT https://community.qlik.com/t5/QlikView/Format-Expression/m-p/1320583#M409339 sunny_talwar 2017-06-06T18:54:10Z