topic Text object: expression for 'percentage' in QlikView https://community.qlik.com/t5/QlikView/Text-object-expression-for-percentage/m-p/277211#M103339 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I use in a text object the following expression to calculate a ratio: =(SCORE/Avg(total(SCORE)). </P><P></P><P>How is it possible to show this ratio as percentage? I want to change a ratio of 0,1 to 10%. </P><P></P><P>Much thanks! Arthur</P></BODY></HTML> Sat, 03 Dec 2011 12:00:16 GMT 2011-12-03T12:00:16Z Text object: expression for 'percentage' https://community.qlik.com/t5/QlikView/Text-object-expression-for-percentage/m-p/277211#M103339 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I use in a text object the following expression to calculate a ratio: =(SCORE/Avg(total(SCORE)). </P><P></P><P>How is it possible to show this ratio as percentage? I want to change a ratio of 0,1 to 10%. </P><P></P><P>Much thanks! Arthur</P></BODY></HTML> Sat, 03 Dec 2011 12:00:16 GMT https://community.qlik.com/t5/QlikView/Text-object-expression-for-percentage/m-p/277211#M103339 2011-12-03T12:00:16Z Text object: expression for 'percentage' https://community.qlik.com/t5/QlikView/Text-object-expression-for-percentage/m-p/277212#M103340 <HTML><HEAD></HEAD><BODY><P><EM>Hi,</EM></P><P></P><P><EM>Try below expression.</EM></P><P></P><P><EM>=Num((SCORE/Avg(total(SCORE)),'##.00%')</EM></P><P></P><P><EM>-Sridhar</EM></P></BODY></HTML> Sat, 03 Dec 2011 14:56:18 GMT https://community.qlik.com/t5/QlikView/Text-object-expression-for-percentage/m-p/277212#M103340 sridhar240784 2011-12-03T14:56:18Z Text object: expression for 'percentage' https://community.qlik.com/t5/QlikView/Text-object-expression-for-percentage/m-p/277213#M103341 <HTML><HEAD></HEAD><BODY><P>Hi Sridhar,</P><P></P><P>Somehow it doesn't work. Do you know why - see below:</P><P><IMG alt="Schermafbeelding 2011-12-03 om 17.07.33.png" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/9194_Schermafbeelding+2011-12-03+om+17.07.33.png" width="450" /></P></BODY></HTML> Sat, 03 Dec 2011 16:08:58 GMT https://community.qlik.com/t5/QlikView/Text-object-expression-for-percentage/m-p/277213#M103341 2011-12-03T16:08:58Z