topic Dynamic Calculation of Previous Year Data in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Calculation-of-Previous-Year-Data/m-p/272419#M1206647 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I just answered my own post THANKS to Mr. John Witherspoon's reply (details below):</P><P><A href="http://community.qlik.com/members/JohnW/default.aspx"><STRONG>John Witherspoon</STRONG></A> <A href="http://community.qlik.com/forums/p/24521/93659.aspx#93659">replied on</A> 01-15-2010 7:44 PM</P><P style="font-weight: bold"></P><P style="font-weight: bold">Using John's reply, I modified my formula to be: sum</P><B></B><P style="font-weight: bold"></P><P></P>({&lt;<B>Year</B>={<B><I>$(=Year-1)</I></B>}&gt;} <B>Sales</B>)/1000 and it worked perfectly. <P>Thanks John.</P><P>Adi</P><P></P><BR /><BR /> <P></P></BODY></HTML> Sat, 21 Aug 2010 19:41:16 GMT 2010-08-21T19:41:16Z Dynamic Calculation of Previous Year Data https://community.qlik.com/t5/QlikView/Dynamic-Calculation-of-Previous-Year-Data/m-p/272418#M1206646 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P>I am very new to Qlikview - only 2 days so please excuse a simple question....</P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <BR /><BR /> <P style="font-weight: bold"></P><P style="font-weight: bold">I have a column in the pivot table which displays the sales of the Year that was selected. E.g. if the Selection is for Year 2008, it displays data for the Sales for Year 2008 correctly using the SelYear formula: sum</P><B></B><P style="font-weight: bold"></P><P></P><P>However, I have another column in which I want to display the previous year's data of the Year selected. E.g. If the Selected Year is 2008 then I want to display the Sales data for Year 2007 in the second colmn called PrevYear.</P>({$&lt;<B>Year</B>=(<B>Year</B>)&gt;}<B>Sales</B>)/ 1000 <BR /><BR /> <P>The formula for PrevYear that I am using is: <B>sum</B>({$&lt;<B>Year</B>=(<B>Year</B>-1)&gt;}<B>Sales</B>)/1000 which does not give me the correct results for sales of 2007. It gives me the same value as in the first column which is the Sales for Year 2008.</P><P>Can somebody please help me.</P><P>Thanks.....Adi</P><P></P></BODY></HTML> Sat, 21 Aug 2010 19:29:25 GMT https://community.qlik.com/t5/QlikView/Dynamic-Calculation-of-Previous-Year-Data/m-p/272418#M1206646 2010-08-21T19:29:25Z Dynamic Calculation of Previous Year Data https://community.qlik.com/t5/QlikView/Dynamic-Calculation-of-Previous-Year-Data/m-p/272419#M1206647 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I just answered my own post THANKS to Mr. John Witherspoon's reply (details below):</P><P><A href="http://community.qlik.com/members/JohnW/default.aspx"><STRONG>John Witherspoon</STRONG></A> <A href="http://community.qlik.com/forums/p/24521/93659.aspx#93659">replied on</A> 01-15-2010 7:44 PM</P><P style="font-weight: bold"></P><P style="font-weight: bold">Using John's reply, I modified my formula to be: sum</P><B></B><P style="font-weight: bold"></P><P></P>({&lt;<B>Year</B>={<B><I>$(=Year-1)</I></B>}&gt;} <B>Sales</B>)/1000 and it worked perfectly. <P>Thanks John.</P><P>Adi</P><P></P><BR /><BR /> <P></P></BODY></HTML> Sat, 21 Aug 2010 19:41:16 GMT https://community.qlik.com/t5/QlikView/Dynamic-Calculation-of-Previous-Year-Data/m-p/272419#M1206647 2010-08-21T19:41:16Z