topic Re: show as a % in QlikView https://community.qlik.com/t5/QlikView/show-as-a/m-p/821569#M1045886 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Apologies...format?</P><P></P><P>Data comes from an excel spreadsheet. This question is one of the colum headers.</P><P></P><P>Chris</P></BODY></HTML> Wed, 26 Nov 2014 08:42:08 GMT 2014-11-26T08:42:08Z show as a % https://community.qlik.com/t5/QlikView/show-as-a/m-p/821567#M1045884 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The following format for an expression in a chart works 99% of the time works to show figures in %.</P><P></P><P>However, for some reason this won't work:</P><P></P><P></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Q17. Was the property clean and free from rubbish]</SPAN><SPAN style="font-size: 8pt;">)/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Q17. Was the property clean and free from rubbish]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;">Any ideas?</SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;">Chris</SPAN></P></BODY></HTML> Wed, 26 Nov 2014 08:37:05 GMT https://community.qlik.com/t5/QlikView/show-as-a/m-p/821567#M1045884 2014-11-26T08:37:05Z Re: show as a % https://community.qlik.com/t5/QlikView/show-as-a/m-p/821568#M1045885 <HTML><HEAD></HEAD><BODY><P>Hi Chris,</P><P></P><P>What format does your field Q17 take?</P></BODY></HTML> Wed, 26 Nov 2014 08:39:21 GMT https://community.qlik.com/t5/QlikView/show-as-a/m-p/821568#M1045885 morganaaron 2014-11-26T08:39:21Z Re: show as a % https://community.qlik.com/t5/QlikView/show-as-a/m-p/821569#M1045886 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Apologies...format?</P><P></P><P>Data comes from an excel spreadsheet. This question is one of the colum headers.</P><P></P><P>Chris</P></BODY></HTML> Wed, 26 Nov 2014 08:42:08 GMT https://community.qlik.com/t5/QlikView/show-as-a/m-p/821569#M1045886 2014-11-26T08:42:08Z Re: show as a % https://community.qlik.com/t5/QlikView/show-as-a/m-p/821570#M1045887 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><SPAN style="font-size: 8pt;"> Count ( </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Q17. Was the property clean and free from rubbish] </SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;"> /</SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> Count</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Q17. Was the property clean and free from rubbish] </SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="font-size: 8pt;">Anand<BR /></SPAN></P></BODY></HTML> Wed, 26 Nov 2014 08:42:12 GMT https://community.qlik.com/t5/QlikView/show-as-a/m-p/821570#M1045887 its_anandrjs 2014-11-26T08:42:12Z