topic Re: Error on text in chart in QlikView https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123842#M370122 <HTML><HEAD></HEAD><BODY><P>Sorry I missed <STRONG style="color: #ff0000;">&gt;}</STRONG></P><P></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>='Ocp: ' &amp; (Num(Count({&lt;DISPO = {'N'}<SPAN style="color: #ff0000;">&gt;}</SPAN> DISPO)/Count(P0703_NOMBRE) ,'#,##0%'))</STRONG></SPAN></P></BODY></HTML> Wed, 11 May 2016 14:51:40 GMT sunny_talwar 2016-05-11T14:51:40Z Error on text in chart https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123839#M370119 <HTML><HEAD></HEAD><BODY><P>Hi, im trying to use ='Ocp: ' &amp; (count(if( DISPO = 'N', DISPO))/Count (P0703_NOMBRE) ,'#,##0%') to have the result in %, but i have error in the expresion</P><P></P><P>any suggestion</P><P></P><P>Tks</P></BODY></HTML> Wed, 11 May 2016 14:47:03 GMT https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123839#M370119 2016-05-11T14:47:03Z Re: Error on text in chart https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123840#M370120 <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>='Ocp: ' &amp; (Num(Count({&lt;DISPO = {'N'} DISPO)/Count(P0703_NOMBRE) ,'#,##0%'))</STRONG></SPAN></P></BODY></HTML> Wed, 11 May 2016 14:48:14 GMT https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123840#M370120 sunny_talwar 2016-05-11T14:48:14Z Re: Error on text in chart https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123841#M370121 <HTML><HEAD></HEAD><BODY><P>H Tks synny but i have the next error:</P><P></P><P>error int ext modifier expression</P></BODY></HTML> Wed, 11 May 2016 14:50:47 GMT https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123841#M370121 2016-05-11T14:50:47Z Re: Error on text in chart https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123842#M370122 <HTML><HEAD></HEAD><BODY><P>Sorry I missed <STRONG style="color: #ff0000;">&gt;}</STRONG></P><P></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>='Ocp: ' &amp; (Num(Count({&lt;DISPO = {'N'}<SPAN style="color: #ff0000;">&gt;}</SPAN> DISPO)/Count(P0703_NOMBRE) ,'#,##0%'))</STRONG></SPAN></P></BODY></HTML> Wed, 11 May 2016 14:51:40 GMT https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123842#M370122 sunny_talwar 2016-05-11T14:51:40Z Re: Error on text in chart https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123843#M370123 <HTML><HEAD></HEAD><BODY><P>I think , did you forget the "num" func at the beggining of the sentence? num(formula,'#,##0%')</P><P></P><P>Ty</P></BODY></HTML> Wed, 11 May 2016 14:52:35 GMT https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123843#M370123 2016-05-11T14:52:35Z Re: Error on text in chart https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123844#M370124 <HTML><HEAD></HEAD><BODY><P>Excelent Tks. it works.</P></BODY></HTML> Wed, 11 May 2016 14:53:39 GMT https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123844#M370124 2016-05-11T14:53:39Z Re: Error on text in chart https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123845#M370125 <HTML><HEAD></HEAD><BODY><P>Great, please close the thread by marking the correct answer</P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Wed, 11 May 2016 14:56:06 GMT https://community.qlik.com/t5/QlikView/Error-on-text-in-chart/m-p/1123845#M370125 sunny_talwar 2016-05-11T14:56:06Z