topic Re: Re: How can I get correct percentage in QlikView https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508335#M1125709 <HTML><HEAD></HEAD><BODY><P>Hi Amelia</P><P></P><P>look at this</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Thu, 19 Dec 2013 13:54:24 GMT 2013-12-19T13:54:24Z How can I get correct percentage https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508332#M1125705 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a straight table and Bar chart. when I am clicking particular month it is showing values 100% in both Straight table and Bar chart. when I am selecting two months it is showing correct percentages. But only for single month it is showing 100% where the values is 34%. How can I get the correct percentage eventhough if I click one month. Please find attched.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 19 Dec 2013 13:39:10 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508332#M1125705 2013-12-19T13:39:10Z Re: How can I get correct percentage https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508333#M1125706 <HTML><HEAD></HEAD><BODY><P>what is your expression , and dimensions?</P></BODY></HTML> Thu, 19 Dec 2013 13:41:54 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508333#M1125706 israrkhan 2013-12-19T13:41:54Z Re: How can I get correct percentage https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508334#M1125707 <HTML><HEAD></HEAD><BODY><P>Please find attached Annuals_COPY.qvw</P></BODY></HTML> Thu, 19 Dec 2013 13:42:42 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508334#M1125707 2013-12-19T13:42:42Z Re: Re: How can I get correct percentage https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508335#M1125709 <HTML><HEAD></HEAD><BODY><P>Hi Amelia</P><P></P><P>look at this</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Thu, 19 Dec 2013 13:54:24 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508335#M1125709 2013-12-19T13:54:24Z Re: How can I get correct percentage https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508336#M1125711 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Sorry I coudn't able to find any change in the qvw. Is that correct?</P></BODY></HTML> Thu, 19 Dec 2013 13:58:06 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508336#M1125711 2013-12-19T13:58:06Z Re: Re: How can I get correct percentage https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508337#M1125712 <HTML><HEAD></HEAD><BODY><P>Hello Amelia,</P><P></P><P>A few suggestions:</P><OL><LI>as your Reference field may contain data of type Text as well as type Number, I would suggest using <SPAN style="color: #0000ff;">Count</SPAN>() rather than <SPAN style="color: #0000ff;">Sum</SPAN>()</LI><LI>By checking the Relative check box, you are forcing QlikView to represent the data in a relative manner compared to the rest. It might throw off your users by thinking the Failure rate is 12% for a given month while it is in fact 24%. The 12% represents the relative amount of failure rate compared to the rest of the months.</LI><LI>If you need the result to be presented in a percentage, you may change the way QlikView displays the result under the <STRONG>Number</STRONG> tab</LI></OL><P></P><P>Please find attached a new version of your QVW file.</P><P></P><P>Regards,</P><P></P><P>Philippe</P></BODY></HTML> Thu, 19 Dec 2013 14:02:43 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508337#M1125712 pgrenier 2013-12-19T14:02:43Z Re: How can I get correct percentage https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508338#M1125714 <HTML><HEAD></HEAD><BODY><P>Amelia,</P><P></P><P>Try this version.&nbsp; I basically unselected the Relative option on the Expression tab and formatted the expression to display with one decimal place as a percent.</P><P></P><P>I hope this helps.</P></BODY></HTML> Thu, 19 Dec 2013 14:16:15 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508338#M1125714 mphekin12 2013-12-19T14:16:15Z Re: How can I get correct percentage https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508339#M1125715 <HTML><HEAD></HEAD><BODY><P>Thanks and it's working.</P></BODY></HTML> Thu, 19 Dec 2013 14:49:32 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508339#M1125715 2013-12-19T14:49:32Z Re: Re: How can I get correct percentage https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508340#M1125717 <HTML><HEAD></HEAD><BODY><P>Hi Amelia</P><P></P><P>sorry it was yours not mine</P><P></P><P>here it is</P><P></P><P>Chris</P></BODY></HTML> Thu, 19 Dec 2013 14:52:06 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-correct-percentage/m-p/508340#M1125717 2013-12-19T14:52:06Z