topic Totaling absolute values in QlikView https://community.qlik.com/t5/QlikView/Totaling-absolute-values/m-p/212072#M66147 <HTML><HEAD></HEAD><BODY><P>Thanks Oleg! ... That was easy...</P></BODY></HTML> Tue, 12 Apr 2011 21:59:06 GMT 2011-04-12T21:59:06Z Totaling absolute values https://community.qlik.com/t5/QlikView/Totaling-absolute-values/m-p/212070#M66145 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a chart that is calculating the variance between 2 numbers: Actual - Forecast. I am also calculating the Variance = Actual - Forecast. When i try to calculate the [Absolute Variance] = fabs(Actual-Forecast) , the numbers within the chart are correct, but the total does not sum up the absolute numbers and appears to still total based on the +/- numbers....</P><P>Any ideas how I can get the total based on the absolute numbers?</P><P>Thx!<BR />Charis</P></BODY></HTML> Tue, 12 Apr 2011 21:27:38 GMT https://community.qlik.com/t5/QlikView/Totaling-absolute-values/m-p/212070#M66145 2011-04-12T21:27:38Z Totaling absolute values https://community.qlik.com/t5/QlikView/Totaling-absolute-values/m-p/212071#M66146 <HTML><HEAD></HEAD><BODY><P>You need to specify at what level of detail do you need the variance to get calculated. In your example, it needs to be done at the monthly level, so the accurate formula would be this:</P><P>sum(AGGR(sum(fabs(Actual-Forecast)), Month))</P><P>The more detailed do you want your calculation to be, the higher the absolute variance becomes...</P></BODY></HTML> Tue, 12 Apr 2011 21:51:02 GMT https://community.qlik.com/t5/QlikView/Totaling-absolute-values/m-p/212071#M66146 Oleg_Troyansky 2011-04-12T21:51:02Z Totaling absolute values https://community.qlik.com/t5/QlikView/Totaling-absolute-values/m-p/212072#M66147 <HTML><HEAD></HEAD><BODY><P>Thanks Oleg! ... That was easy...</P></BODY></HTML> Tue, 12 Apr 2011 21:59:06 GMT https://community.qlik.com/t5/QlikView/Totaling-absolute-values/m-p/212072#M66147 2011-04-12T21:59:06Z