topic Problem with accumulation in QlikView https://community.qlik.com/t5/QlikView/Problem-with-accumulation/m-p/371587#M138138 <HTML><HEAD></HEAD><BODY><P>I have the following table</P><P></P><P>day&nbsp;&nbsp;&nbsp;&nbsp; monthyear&nbsp;&nbsp;&nbsp;&nbsp; total&nbsp;&nbsp;&nbsp;&nbsp; accum&nbsp;&nbsp;&nbsp;&nbsp; dailyAvg</P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 271&nbsp;&nbsp;&nbsp;&nbsp; 271&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ??</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 311&nbsp;&nbsp;&nbsp;&nbsp; 582</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 328&nbsp;&nbsp;&nbsp;&nbsp; 910</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 338&nbsp;&nbsp;&nbsp;&nbsp; 1248</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 309&nbsp;&nbsp;&nbsp;&nbsp; 1557</P><P>6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 295&nbsp;&nbsp;&nbsp;&nbsp; 1852</P><P>7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 341&nbsp;&nbsp;&nbsp;&nbsp; 2193</P><P>8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 333&nbsp;&nbsp;&nbsp;&nbsp; 2526</P><P>....</P><P>31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 332&nbsp;&nbsp;&nbsp;&nbsp; 9953</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jun12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 345&nbsp;&nbsp;&nbsp;&nbsp; 345</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jun12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 310&nbsp;&nbsp;&nbsp;&nbsp; 655&nbsp;&nbsp; </P><P>...</P><P></P><P>i performed the expression "accum" by copying the TOTAL column and activating the switch "full Accumulation", then I tried to make a daily average and for it i created the term "dayavg" as "accum / day" but the result I get is like "TOTAL / day", any ideas?</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 27 Jun 2012 20:12:39 GMT 2012-06-27T20:12:39Z Problem with accumulation https://community.qlik.com/t5/QlikView/Problem-with-accumulation/m-p/371587#M138138 <HTML><HEAD></HEAD><BODY><P>I have the following table</P><P></P><P>day&nbsp;&nbsp;&nbsp;&nbsp; monthyear&nbsp;&nbsp;&nbsp;&nbsp; total&nbsp;&nbsp;&nbsp;&nbsp; accum&nbsp;&nbsp;&nbsp;&nbsp; dailyAvg</P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 271&nbsp;&nbsp;&nbsp;&nbsp; 271&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ??</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 311&nbsp;&nbsp;&nbsp;&nbsp; 582</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 328&nbsp;&nbsp;&nbsp;&nbsp; 910</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 338&nbsp;&nbsp;&nbsp;&nbsp; 1248</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 309&nbsp;&nbsp;&nbsp;&nbsp; 1557</P><P>6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 295&nbsp;&nbsp;&nbsp;&nbsp; 1852</P><P>7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 341&nbsp;&nbsp;&nbsp;&nbsp; 2193</P><P>8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 333&nbsp;&nbsp;&nbsp;&nbsp; 2526</P><P>....</P><P>31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; may12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 332&nbsp;&nbsp;&nbsp;&nbsp; 9953</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jun12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 345&nbsp;&nbsp;&nbsp;&nbsp; 345</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jun12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 310&nbsp;&nbsp;&nbsp;&nbsp; 655&nbsp;&nbsp; </P><P>...</P><P></P><P>i performed the expression "accum" by copying the TOTAL column and activating the switch "full Accumulation", then I tried to make a daily average and for it i created the term "dayavg" as "accum / day" but the result I get is like "TOTAL / day", any ideas?</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 27 Jun 2012 20:12:39 GMT https://community.qlik.com/t5/QlikView/Problem-with-accumulation/m-p/371587#M138138 2012-06-27T20:12:39Z Re: Problem with accumulation https://community.qlik.com/t5/QlikView/Problem-with-accumulation/m-p/371588#M138139 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can see my example.</P><P>I hope this helps.</P></BODY></HTML> Thu, 28 Jun 2012 02:33:24 GMT https://community.qlik.com/t5/QlikView/Problem-with-accumulation/m-p/371588#M138139 fernando_tonial 2012-06-28T02:33:24Z Re: Problem with accumulation https://community.qlik.com/t5/QlikView/Problem-with-accumulation/m-p/371589#M138140 <HTML><HEAD></HEAD><BODY><P>Fernando...that's exactly what I needed!!! Thank you!</P></BODY></HTML> Thu, 28 Jun 2012 19:18:25 GMT https://community.qlik.com/t5/QlikView/Problem-with-accumulation/m-p/371589#M138140 2012-06-28T19:18:25Z