topic error in table totals for variance in QlikView https://community.qlik.com/t5/QlikView/error-in-table-totals-for-variance/m-p/183478#M48715 <HTML><HEAD></HEAD><BODY><P>Louw,</P><P>Why are you putting the total mode to sum of all rows? That tells me the expression total doesn't match the sum of the rows for some reason which is generally not a good thing to have happen and that's why the total variance doesn't work because it has to based on expression total since it is a percentage.</P><P>Regards.</P></BODY></HTML> Sun, 27 Mar 2011 18:43:18 GMT pover 2011-03-27T18:43:18Z error in table totals for variance https://community.qlik.com/t5/QlikView/error-in-table-totals-for-variance/m-p/183477#M48714 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am using a table to calculate growth against budget. The row calculations seems to be correct but i am batteling to get the total correct. I would appreciate help with this.</P><P>Attached are screenshots of the problem.</P><P>I have tried pivot table but also get wrong values with variance totals?</P><P>I would appreciate help with this.</P><P></P><P>thks</P><P>Louw</P></BODY></HTML> Sun, 27 Mar 2011 09:41:54 GMT https://community.qlik.com/t5/QlikView/error-in-table-totals-for-variance/m-p/183477#M48714 2011-03-27T09:41:54Z error in table totals for variance https://community.qlik.com/t5/QlikView/error-in-table-totals-for-variance/m-p/183478#M48715 <HTML><HEAD></HEAD><BODY><P>Louw,</P><P>Why are you putting the total mode to sum of all rows? That tells me the expression total doesn't match the sum of the rows for some reason which is generally not a good thing to have happen and that's why the total variance doesn't work because it has to based on expression total since it is a percentage.</P><P>Regards.</P></BODY></HTML> Sun, 27 Mar 2011 18:43:18 GMT https://community.qlik.com/t5/QlikView/error-in-table-totals-for-variance/m-p/183478#M48715 pover 2011-03-27T18:43:18Z error in table totals for variance https://community.qlik.com/t5/QlikView/error-in-table-totals-for-variance/m-p/183479#M48716 <HTML><HEAD></HEAD><BODY><P>Hi Karl,</P><P>Thank you for your reply. I am hiding certain fields in my table that i used in calculations that got me totally confused. By just reading your reply i am back on track and took off all the total sum check box and put in on use expression and it is working now.</P><P></P><P>Thank you</P><P>Regards</P><P>Louw</P></BODY></HTML> Mon, 28 Mar 2011 10:12:25 GMT https://community.qlik.com/t5/QlikView/error-in-table-totals-for-variance/m-p/183479#M48716 2011-03-28T10:12:25Z