topic Re: How to do a rolling value in QlikView https://community.qlik.com/t5/QlikView/How-to-do-a-rolling-value/m-p/387677#M1273876 <HTML><HEAD></HEAD><BODY><P>yeah.</P><P></P><P>Good answer........ <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards,</P><P>Kabilan K</P></BODY></HTML> Thu, 29 Nov 2012 10:44:57 GMT 2012-11-29T10:44:57Z How to do a rolling value https://community.qlik.com/t5/QlikView/How-to-do-a-rolling-value/m-p/387675#M1273869 <HTML><HEAD></HEAD><BODY><P>I have some values which are separate for each of the months. However I would like it to be displayed in a rolling total so January would simply have January's figure in but February would have their value in as well as January's. </P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="130" style="width: 897px; border: 1px solid rgb(0, 0, 0); height: 121px;"><TBODY><TR><TH style="background-color: #6690bc; color: #333333; text-align: -webkit-center; padding: 3px; font-family: arial, helvetica, sans-serif;"><STRONG style="color: #ffffff;">Month</STRONG><BR /></TH><TH style="background-color: #6690bc; color: #333333; text-align: -webkit-center; padding: 3px; font-family: arial, helvetica, sans-serif;"><STRONG style="color: #ffffff;">Value</STRONG><BR /></TH><TH style="background-color: #6690bc; color: #333333; text-align: -webkit-center; padding: 3px; font-family: arial, helvetica, sans-serif;"><P><SPAN style="color: #ffffff;"><STRONG>Expected </STRONG></SPAN></P><P><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></P></TH></TR><TR><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">Jan</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">2</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">2</TD></TR><TR><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">Feb</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">3</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">5</TD></TR><TR><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">Mar</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">2</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">7</TD></TR><TR><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">April</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">1</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">8</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/How-to-do-a-rolling-value/m-p/387675#M1273869 2026-01-26T18:19:17Z Re: How to do a rolling value https://community.qlik.com/t5/QlikView/How-to-do-a-rolling-value/m-p/387676#M1273872 <HTML><HEAD></HEAD><BODY><P>Use Month as Dimension.</P><P>Expression Label: ValueExp</P><P>Expression : Alt(Above([ValueExp]),0) +Sum(Value)</P><P></P><P>Or </P><P>Use Fully Accumulated option in the Expression tab under Accumulation section.</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 28 Nov 2012 17:31:28 GMT https://community.qlik.com/t5/QlikView/How-to-do-a-rolling-value/m-p/387676#M1273872 CELAMBARASAN 2012-11-28T17:31:28Z Re: How to do a rolling value https://community.qlik.com/t5/QlikView/How-to-do-a-rolling-value/m-p/387677#M1273876 <HTML><HEAD></HEAD><BODY><P>yeah.</P><P></P><P>Good answer........ <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards,</P><P>Kabilan K</P></BODY></HTML> Thu, 29 Nov 2012 10:44:57 GMT https://community.qlik.com/t5/QlikView/How-to-do-a-rolling-value/m-p/387677#M1273876 2012-11-29T10:44:57Z