topic Re: Wrong Percentage values in QlikView https://community.qlik.com/t5/QlikView/Wrong-Percentage-values/m-p/831486#M1008181 <HTML><HEAD></HEAD><BODY><P>Upload your qvw, please. It will be easier to undestand your problem and help you.</P><P>Regards</P><P>MR</P></BODY></HTML> Mon, 11 May 2015 08:47:41 GMT mrossoit 2015-05-11T08:47:41Z Wrong Percentage values https://community.qlik.com/t5/QlikView/Wrong-Percentage-values/m-p/831483#M1008178 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using one stacked bar chart in my dashboard. In this chart I am using two dimension and one expression.</P><P>This chart shows values more than 100%. Please see below screenshot</P><P><IMG __jive_id="86121" alt="more.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86121_more.png" style="width: 620px; height: 171px;" /></P><P>This calculation is wrong.It should not be more than 100%. I am using below expression</P><P></P><P></P><P><SPAN style="color: #0000ff;">Sum</SPAN>(HOURS)</P><P></P><P>/</P><P></P><P>(</P><P></P><P>(</P><P></P><P>sum({&lt;FlgValue=, GName=,OMode=,OName=,Site=,Project=,Time={<SPAN style="color: #800000;">" Time:9 AM - 7 PM"</SPAN>}&gt;} total &lt;<STRONG style="color: #808080;"><EM>$(=GetCurrentField(Xaxis))</EM></STRONG>&gt; aggr(Count({&lt;FlgValue=, GName=,OMode=,OName=,Site=,Project=,Time={<SPAN style="color: #800000;">" Time:9 AM - 7 PM"</SPAN>}&gt;} Distinct Date), KEY, Week))</P><P></P><P>*</P><P></P><P>Count({&lt;FlgValue=,Project=, OName=,OMode=,Site=,GName=,Time={<SPAN style="color: #800000;">" Time:9 AM - 7 PM"</SPAN>}&gt;} Distinct total &lt;Week&gt; Hour)</P><P></P><P>)</P><P></P><P>+</P><P></P><P>(</P><P></P><P>sum({&lt;FlgValue=, GName=,OMode=,OName=,Site=,Project=,Time-={<SPAN style="color: #800000;">" Time:9 AM - 7 PM"</SPAN>}&gt;} total &lt;<STRONG style="color: #808080;"><EM>$(=GetCurrentField(Xaxis))</EM></STRONG>&gt; aggr(Count({&lt;FlgValue=, GName=,OMode=,OName=,Site=,Project=,Time-={<SPAN style="color: #800000;">" Time:9 AM - 7 PM"</SPAN>}&gt;} Distinct Date), KEY, Week))</P><P></P><P>*</P><P></P><P>Count({&lt;FlgValue=,Project=, OName=,OMode=,Site=,GName=,Time-={<SPAN style="color: #800000;">" Time:9 AM - 7 PM"</SPAN>}&gt;} Distinct total &lt;Week&gt; Hour)</P><P></P><P>)</P><P></P><P>)</P><P></P><P><SPAN style="; color: #ff8000; text-decoration: underline;"><STRONG>) </STRONG></SPAN></P><P></P><P><SPAN style="color: #ff8000;">Please help me to solve this.</SPAN></P><P><SPAN style="color: #ff8000;">Thanks.</SPAN></P></BODY></HTML> Mon, 11 May 2015 07:00:22 GMT https://community.qlik.com/t5/QlikView/Wrong-Percentage-values/m-p/831483#M1008178 soha1902 2015-05-11T07:00:22Z Re: Wrong Percentage values https://community.qlik.com/t5/QlikView/Wrong-Percentage-values/m-p/831484#M1008179 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/soha1902">soha1902</A></STRONG>,</P><P>Can you attach the sample data with the file.</P></BODY></HTML> Mon, 11 May 2015 07:10:58 GMT https://community.qlik.com/t5/QlikView/Wrong-Percentage-values/m-p/831484#M1008179 qlikviewwizard 2015-05-11T07:10:58Z Re: Wrong Percentage values https://community.qlik.com/t5/QlikView/Wrong-Percentage-values/m-p/831485#M1008180 <HTML><HEAD></HEAD><BODY><P>Any Suggestions???</P></BODY></HTML> Mon, 11 May 2015 08:07:43 GMT https://community.qlik.com/t5/QlikView/Wrong-Percentage-values/m-p/831485#M1008180 soha1902 2015-05-11T08:07:43Z Re: Wrong Percentage values https://community.qlik.com/t5/QlikView/Wrong-Percentage-values/m-p/831486#M1008181 <HTML><HEAD></HEAD><BODY><P>Upload your qvw, please. It will be easier to undestand your problem and help you.</P><P>Regards</P><P>MR</P></BODY></HTML> Mon, 11 May 2015 08:47:41 GMT https://community.qlik.com/t5/QlikView/Wrong-Percentage-values/m-p/831486#M1008181 mrossoit 2015-05-11T08:47:41Z