topic Getting Percentage in Guage chart in QlikView https://community.qlik.com/t5/QlikView/Getting-Percentage-in-Guage-chart/m-p/207061#M1209268 <HTML><HEAD></HEAD><BODY><P>Hi Ben,</P><P>Dis you try using the NUM function?</P><P>= NUM<STRONG>( expresion, '#,##0.0 %')</STRONG></P><P>I hope this help you.</P><P>Best regards.</P></BODY></HTML> Mon, 21 Dec 2009 21:59:39 GMT 2009-12-21T21:59:39Z Getting Percentage in Guage chart https://community.qlik.com/t5/QlikView/Getting-Percentage-in-Guage-chart/m-p/207060#M1209267 <HTML><HEAD></HEAD><BODY><P>Hi, I have a guage chart that I'm using, however I want to show the percentage on the chart too, so I have added the text, using expression:</P><P style="margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;">=(<B>Sum</B> ((<B>IF</B>(<B>Type</B>='AA',<B>[Budget Amount]</B>))))/(<B>Sum</B> ((<B>IF</B>(<B>Type</B>='BA',<B>[Budget Amount]</B>))))*100</P><P>However, there are a few problems, namely it doesnt have the % symbol after it and its not limited to any decimal places- how can I change this expression to include the % text after it and to only display 1 d.p. so it looks like this:</P><P>24.1 %</P><P>instead of 24.12333311222445511</P><P>Cheers</P><P>Ben</P></BODY></HTML> Mon, 21 Dec 2009 21:46:22 GMT https://community.qlik.com/t5/QlikView/Getting-Percentage-in-Guage-chart/m-p/207060#M1209267 2009-12-21T21:46:22Z Getting Percentage in Guage chart https://community.qlik.com/t5/QlikView/Getting-Percentage-in-Guage-chart/m-p/207061#M1209268 <HTML><HEAD></HEAD><BODY><P>Hi Ben,</P><P>Dis you try using the NUM function?</P><P>= NUM<STRONG>( expresion, '#,##0.0 %')</STRONG></P><P>I hope this help you.</P><P>Best regards.</P></BODY></HTML> Mon, 21 Dec 2009 21:59:39 GMT https://community.qlik.com/t5/QlikView/Getting-Percentage-in-Guage-chart/m-p/207061#M1209268 2009-12-21T21:59:39Z Getting Percentage in Guage chart https://community.qlik.com/t5/QlikView/Getting-Percentage-in-Guage-chart/m-p/207062#M1209269 <HTML><HEAD></HEAD><BODY><P>Thanks very much! Just what I was after!</P></BODY></HTML> Mon, 21 Dec 2009 22:49:31 GMT https://community.qlik.com/t5/QlikView/Getting-Percentage-in-Guage-chart/m-p/207062#M1209269 2009-12-21T22:49:31Z