topic This Year vs Previous Year in QlikView https://community.qlik.com/t5/QlikView/This-Year-vs-Previous-Year/m-p/696120#M251522 <HTML><HEAD></HEAD><BODY><P>I have Year and Sales data.</P><P>Now I want if user select any year then table will show selected year and previous year sales.</P><P>Please help me. Sample app attached.</P></BODY></HTML> Thu, 17 Jul 2014 09:21:56 GMT soha1902 2014-07-17T09:21:56Z This Year vs Previous Year https://community.qlik.com/t5/QlikView/This-Year-vs-Previous-Year/m-p/696120#M251522 <HTML><HEAD></HEAD><BODY><P>I have Year and Sales data.</P><P>Now I want if user select any year then table will show selected year and previous year sales.</P><P>Please help me. Sample app attached.</P></BODY></HTML> Thu, 17 Jul 2014 09:21:56 GMT https://community.qlik.com/t5/QlikView/This-Year-vs-Previous-Year/m-p/696120#M251522 soha1902 2014-07-17T09:21:56Z Re: This Year vs Previous Year https://community.qlik.com/t5/QlikView/This-Year-vs-Previous-Year/m-p/696121#M251523 <HTML><HEAD></HEAD><BODY><P>Hi Soha,</P><P></P><P>PFA Hope this will solve your issue.</P><P></P><P>Current Year = sum({&lt;Year= {'$(=Max(Year))'}&gt;} Sales2)</P><P></P><P>Previous Year = sum({&lt;Year= {'$(=Max(Year)-1)'}&gt;} Sales2)</P><P></P><P>-- Regards,</P><P>Vishal Waghole</P></BODY></HTML> Thu, 17 Jul 2014 10:43:20 GMT https://community.qlik.com/t5/QlikView/This-Year-vs-Previous-Year/m-p/696121#M251523 VishalWaghole 2014-07-17T10:43:20Z Re: This Year vs Previous Year https://community.qlik.com/t5/QlikView/This-Year-vs-Previous-Year/m-p/696122#M251524 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Go here <A href="https://community.qlik.com/thread/124394">Current Period and Last year Same Period</A></P><P>Hope it helps you</P></BODY></HTML> Thu, 17 Jul 2014 11:04:15 GMT https://community.qlik.com/t5/QlikView/This-Year-vs-Previous-Year/m-p/696122#M251524 er_mohit 2014-07-17T11:04:15Z