topic Re: Expression total is not actually displaying sum of all values in QlikView https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915428#M317564 <HTML><HEAD></HEAD><BODY><P>can u tell me wats the reason and how it is working?</P></BODY></HTML> Fri, 07 Aug 2015 12:59:18 GMT 2015-08-07T12:59:18Z Expression total is not actually displaying sum of all values https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915425#M317561 <HTML><HEAD></HEAD><BODY><P>Hi dudes,</P><P>I have 1 dimension and 1 expression.</P><P>I have bar chart which can be changed o pivtot table.</P><P>the individual monthly values on bar chart/pivot table are correct.</P><P>but on left corner&nbsp; over bar chart/pivot table; we can see 3751 as total. it is wrong. sum of all individual values of all months gives 3768.</P><P>can any 1 tell me how to make 3768 get displayed and wat is going wrong?</P><P></P><P>also i am attaching qvw.</P></BODY></HTML> Fri, 07 Aug 2015 12:50:43 GMT https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915425#M317561 2015-08-07T12:50:43Z Re: Expression total is not actually displaying sum of all values https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915426#M317562 <HTML><HEAD></HEAD><BODY><P>Try this as your expression:</P><P></P><P><STRONG>Sum(Aggr(YourCurrentExpression, YourChartDimensions))</STRONG></P></BODY></HTML> Fri, 07 Aug 2015 12:52:20 GMT https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915426#M317562 sunny_talwar 2015-08-07T12:52:20Z Re: Expression total is not actually displaying sum of all values https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915427#M317563 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Fri, 07 Aug 2015 12:55:25 GMT https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915427#M317563 qlikmsg4u 2015-08-07T12:55:25Z Re: Expression total is not actually displaying sum of all values https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915428#M317564 <HTML><HEAD></HEAD><BODY><P>can u tell me wats the reason and how it is working?</P></BODY></HTML> Fri, 07 Aug 2015 12:59:18 GMT https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915428#M317564 2015-08-07T12:59:18Z Re: Expression total is not actually displaying sum of all values https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915429#M317565 <HTML><HEAD></HEAD><BODY><P>hey kn ..this is wat sunny has posted....it is wrking. can u tell me wat is the reason?</P></BODY></HTML> Fri, 07 Aug 2015 13:00:48 GMT https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915429#M317565 2015-08-07T13:00:48Z Re: Expression total is not actually displaying sum of all values https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915430#M317566 <HTML><HEAD></HEAD><BODY><P>Hi Prudhvi,</P><P></P><P>the total of 3751 is the correct value for the expression, the expression total isn't affected by your dimension and so if you look at your whole data set and count the number of distinct employee numbers terminated in 2014 it is indeed 3751. <SPAN style="font-size: 10pt; line-height: 1.5em;">This number doesn't count employees which are terminated multiple times in <STRONG>different</STRONG> months.</SPAN></P><P></P><P>Employee 34149 for example was terminated in Feb and Mar, so will count in your bar chart twice, one for each month. However will only count a single time in the expression total.</P><P></P><P>The answer Sunny provided ensures your dimension is taken into account and so counted twice, like how you expect it to.</P><P></P><P>Hope that helps explain</P><P>Joe</P></BODY></HTML> Fri, 07 Aug 2015 13:14:58 GMT https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915430#M317566 2015-08-07T13:14:58Z Re: Expression total is not actually displaying sum of all values https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915431#M317567 <HTML><HEAD></HEAD><BODY><P>Nice....Dude Thanks alot<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 10 Aug 2015 06:18:20 GMT https://community.qlik.com/t5/QlikView/Expression-total-is-not-actually-displaying-sum-of-all-values/m-p/915431#M317567 2015-08-10T06:18:20Z