topic Re: measure for the previous dimension value in QlikView https://community.qlik.com/t5/QlikView/measure-for-the-previous-dimension-value/m-p/830572#M1231465 <HTML><HEAD></HEAD><BODY><P>sum(sales) - above(sum(sales))</P></BODY></HTML> Mon, 11 May 2015 05:23:22 GMT Anonymous 2015-05-11T05:23:22Z measure for the previous dimension value https://community.qlik.com/t5/QlikView/measure-for-the-previous-dimension-value/m-p/830571#M1231463 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>i have a table which shows sales measure for each Week Id. now i want to have another column which shows the increase from previous week; something lie this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Week Id</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Increase</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">23</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">7</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">-5</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">5</TD></TR></TBODY></TABLE><P> How Should i set the expression?</P><P></P><P>Regards</P><P>Mana</P></BODY></HTML> Mon, 26 Jan 2026 21:26:37 GMT https://community.qlik.com/t5/QlikView/measure-for-the-previous-dimension-value/m-p/830571#M1231463 2026-01-26T21:26:37Z Re: measure for the previous dimension value https://community.qlik.com/t5/QlikView/measure-for-the-previous-dimension-value/m-p/830572#M1231465 <HTML><HEAD></HEAD><BODY><P>sum(sales) - above(sum(sales))</P></BODY></HTML> Mon, 11 May 2015 05:23:22 GMT https://community.qlik.com/t5/QlikView/measure-for-the-previous-dimension-value/m-p/830572#M1231465 Anonymous 2015-05-11T05:23:22Z Re: measure for the previous dimension value https://community.qlik.com/t5/QlikView/measure-for-the-previous-dimension-value/m-p/830573#M1231468 <HTML><HEAD></HEAD><BODY><P>thanks dear Greeshma</P></BODY></HTML> Mon, 11 May 2015 05:54:36 GMT https://community.qlik.com/t5/QlikView/measure-for-the-previous-dimension-value/m-p/830573#M1231468 2015-05-11T05:54:36Z