topic Re: Progressive values in QlikView https://community.qlik.com/t5/QlikView/Progressive-values/m-p/433533#M1163314 <HTML><HEAD></HEAD><BODY><P>Please see attached</P><P></P><P>Regards</P><P>Mhatim</P></BODY></HTML> Fri, 19 Oct 2012 13:51:18 GMT 2012-10-19T13:51:18Z Progressive values https://community.qlik.com/t5/QlikView/Progressive-values/m-p/433532#M1163313 <HTML><HEAD></HEAD><BODY><P>Dear all, my legs are tied and I can't go on.</P><P>I don't know how to solve this problem. I've the following table:</P><P></P><P>Year Month&nbsp;&nbsp;&nbsp;&nbsp; WhValue</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2300</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4500</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6900</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7500</P><P>....</P><P>...</P><P></P><P>WhValue is a progressive, therefore if I would know the exactly values per months , I should do&nbsp; the difference between February and January (2300 - 1000) and so on.&nbsp; How can I calculate these values in the script, in order to have the following table</P><P></P><P>Year Month&nbsp;&nbsp;&nbsp; Value per Month</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1300</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2200</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2400</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600</P><P></P><P></P><P>Thanks in advance fopr your support</P><P>stefan</P></BODY></HTML> Fri, 19 Oct 2012 13:45:05 GMT https://community.qlik.com/t5/QlikView/Progressive-values/m-p/433532#M1163313 Anonymous 2012-10-19T13:45:05Z Re: Progressive values https://community.qlik.com/t5/QlikView/Progressive-values/m-p/433533#M1163314 <HTML><HEAD></HEAD><BODY><P>Please see attached</P><P></P><P>Regards</P><P>Mhatim</P></BODY></HTML> Fri, 19 Oct 2012 13:51:18 GMT https://community.qlik.com/t5/QlikView/Progressive-values/m-p/433533#M1163314 2012-10-19T13:51:18Z Re: Progressive values https://community.qlik.com/t5/QlikView/Progressive-values/m-p/433534#M1163315 <HTML><HEAD></HEAD><BODY><P>well test</P></BODY></HTML> Fri, 19 Oct 2012 13:53:45 GMT https://community.qlik.com/t5/QlikView/Progressive-values/m-p/433534#M1163315 2012-10-19T13:53:45Z Re: Progressive values https://community.qlik.com/t5/QlikView/Progressive-values/m-p/433535#M1163316 <HTML><HEAD></HEAD><BODY><P>Great Cristina !!</P><P>Thanks very much</P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 19 Oct 2012 15:04:25 GMT https://community.qlik.com/t5/QlikView/Progressive-values/m-p/433535#M1163316 Anonymous 2012-10-19T15:04:25Z