topic Sale Difference in Two Years in QlikView https://community.qlik.com/t5/QlikView/Sale-Difference-in-Two-Years/m-p/229734#M81622 <HTML><HEAD></HEAD><BODY><P>hi all...</P><P></P><P>I am a newbie in qlikview ,</P><P></P><P>So, please tell me how we Calculate Sale Difference for two years.</P><P></P><P>Hope for help....</P><P></P><P>thanx in advance.......</P><P></P><P></P><P>Best Regards --</P><P>Shekhar Munjal</P></BODY></HTML> Fri, 25 Feb 2011 06:17:30 GMT 2011-02-25T06:17:30Z Sale Difference in Two Years https://community.qlik.com/t5/QlikView/Sale-Difference-in-Two-Years/m-p/229734#M81622 <HTML><HEAD></HEAD><BODY><P>hi all...</P><P></P><P>I am a newbie in qlikview ,</P><P></P><P>So, please tell me how we Calculate Sale Difference for two years.</P><P></P><P>Hope for help....</P><P></P><P>thanx in advance.......</P><P></P><P></P><P>Best Regards --</P><P>Shekhar Munjal</P></BODY></HTML> Fri, 25 Feb 2011 06:17:30 GMT https://community.qlik.com/t5/QlikView/Sale-Difference-in-Two-Years/m-p/229734#M81622 2011-02-25T06:17:30Z Sale Difference in Two Years https://community.qlik.com/t5/QlikView/Sale-Difference-in-Two-Years/m-p/229735#M81623 <HTML><HEAD></HEAD><BODY><P>Hi Shekhar</P><P></P><P>According to Your question , You can use set analysis</P><P>current year sales= sum({$&lt;Year={$(=Max(Year))}&gt;}Sales)</P><P>previous Year Sales= sum({$&lt;Year={$(=Max(Year)-1)}&gt;}Sales)</P><P>now</P><P>column(2)-column(1)</P><P></P><P>hope it works</P><P>Thanks</P></BODY></HTML> Fri, 25 Feb 2011 06:38:52 GMT https://community.qlik.com/t5/QlikView/Sale-Difference-in-Two-Years/m-p/229735#M81623 2011-02-25T06:38:52Z Sale Difference in Two Years https://community.qlik.com/t5/QlikView/Sale-Difference-in-Two-Years/m-p/229736#M81624 <HTML><HEAD></HEAD><BODY><P>hi Vimlesh ...</P><P></P><P>this Expression start works for me ...</P><P></P><P>thanx.......</P><P></P><P>Best Regards --</P><P>Shekhar Munjal</P></BODY></HTML> Fri, 25 Feb 2011 06:58:48 GMT https://community.qlik.com/t5/QlikView/Sale-Difference-in-Two-Years/m-p/229736#M81624 2011-02-25T06:58:48Z