topic Previous Year Value Calculation in QlikView https://community.qlik.com/t5/QlikView/Previous-Year-Value-Calculation/m-p/474776#M177268 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I have data in this manner :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD class="xl63" height="20" width="64">Year</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Product</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Sales</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2000</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2001</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">189</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2002</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">154</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2003</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">145</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2000</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2001</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">87</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2002</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">45</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2003</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67</TD></TR></TBODY></TABLE><P></P><P>I need to have one more Column to have "Previous Year Sales" for Year and Product.</P><P></P><P>Final Result will be like this :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 328px;"><TBODY><TR><TD class="xl65" height="20" width="64">Year</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Product</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Sales</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="136">Previous_Year_Sales</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2000</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2001</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">189</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2002</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">154</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">189</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2003</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">145</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">154</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2000</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2001</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">87</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2002</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">45</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">87</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2003</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">45</TD></TR></TBODY></TABLE><P></P><P>How can I achieve this ? Kindly help</P><P></P><P>Regards,</P><P>Kumar</P></BODY></HTML> Wed, 16 Oct 2013 06:25:07 GMT 2013-10-16T06:25:07Z Previous Year Value Calculation https://community.qlik.com/t5/QlikView/Previous-Year-Value-Calculation/m-p/474776#M177268 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I have data in this manner :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD class="xl63" height="20" width="64">Year</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Product</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Sales</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2000</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2001</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">189</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2002</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">154</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2003</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">145</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2000</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2001</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">87</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2002</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">45</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2003</TD><TD class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl64" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67</TD></TR></TBODY></TABLE><P></P><P>I need to have one more Column to have "Previous Year Sales" for Year and Product.</P><P></P><P>Final Result will be like this :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 328px;"><TBODY><TR><TD class="xl65" height="20" width="64">Year</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Product</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Sales</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="136">Previous_Year_Sales</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2000</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2001</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">189</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2002</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">154</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">189</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2003</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P1</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">145</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">154</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2000</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2001</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">87</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2002</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">45</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">87</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">2003</TD><TD class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">P2</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67</TD><TD align="right" class="xl66" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">45</TD></TR></TBODY></TABLE><P></P><P>How can I achieve this ? Kindly help</P><P></P><P>Regards,</P><P>Kumar</P></BODY></HTML> Wed, 16 Oct 2013 06:25:07 GMT https://community.qlik.com/t5/QlikView/Previous-Year-Value-Calculation/m-p/474776#M177268 2013-10-16T06:25:07Z Re: Previous Year Value Calculation https://community.qlik.com/t5/QlikView/Previous-Year-Value-Calculation/m-p/474777#M177269 <HTML><HEAD></HEAD><BODY><P>Front-end - use Above() function</P><P>Script - use Peek() function</P><P></P><P>Update: PFA</P></BODY></HTML> Wed, 16 Oct 2013 06:27:06 GMT https://community.qlik.com/t5/QlikView/Previous-Year-Value-Calculation/m-p/474777#M177269 tresB 2013-10-16T06:27:06Z Re: Previous Year Value Calculation https://community.qlik.com/t5/QlikView/Previous-Year-Value-Calculation/m-p/474778#M177270 <HTML><HEAD></HEAD><BODY><P>Thanks Tresesco <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 16 Oct 2013 09:20:41 GMT https://community.qlik.com/t5/QlikView/Previous-Year-Value-Calculation/m-p/474778#M177270 2013-10-16T09:20:41Z