topic Re: Accumalative Value in QlikView https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155745#M520694 <HTML><HEAD></HEAD><BODY><P>Imbalance is the calculated feild</P></BODY></HTML> Fri, 01 Jul 2016 08:55:46 GMT 2016-07-01T08:55:46Z Accumalative Value https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155741#M520690 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have an issue, I have a straight table with 2 dimensions, DATE and PERIOD, there is a calculation on this table, and then I was to accumulate the calculation. the "full accumulation" option on the expressions tab is not working and all the calcs that I am trying either over add or simply bring back the line's result...please assist.</P><P></P><P>Current Formulae:</P><P><SPAN style="font-size: 8pt;">=Imbalance+RangeSum(above(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Settlement Total]</SPAN><SPAN style="font-size: 8pt;">-</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Stratus Total]</SPAN><SPAN style="font-size: 8pt;">,0,RowNo())) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Thanks</SPAN></P></BODY></HTML> Fri, 01 Jul 2016 08:19:12 GMT https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155741#M520690 2016-07-01T08:19:12Z Re: Accumalative Value https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155742#M520691 <HTML><HEAD></HEAD><BODY><P>Do you want to Accumulate with both Dimensions?</P><P>Can you provide sample data?</P></BODY></HTML> Fri, 01 Jul 2016 08:25:36 GMT https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155742#M520691 MK_QSL 2016-07-01T08:25:36Z Re: Accumalative Value https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155743#M520692 <HTML><HEAD></HEAD><BODY><P>What is Imbalance here? That doesn't need to be fully accumulated?</P></BODY></HTML> Fri, 01 Jul 2016 08:33:02 GMT https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155743#M520692 sunny_talwar 2016-07-01T08:33:02Z Re: Accumalative Value https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155744#M520693 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P>Yes I would assume that I would.</P><P>Regards</P></BODY></HTML> Fri, 01 Jul 2016 08:55:07 GMT https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155744#M520693 2016-07-01T08:55:07Z Re: Accumalative Value https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155745#M520694 <HTML><HEAD></HEAD><BODY><P>Imbalance is the calculated feild</P></BODY></HTML> Fri, 01 Jul 2016 08:55:46 GMT https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155745#M520694 2016-07-01T08:55:46Z Re: Accumalative Value https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155746#M520695 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can u provide sample data or qvw?</P></BODY></HTML> Fri, 01 Jul 2016 10:41:26 GMT https://community.qlik.com/t5/QlikView/Accumalative-Value/m-p/1155746#M520695 Anonymous 2016-07-01T10:41:26Z