topic Re: Year comparison in QlikView https://community.qlik.com/t5/QlikView/Year-comparison/m-p/670236#M243554 <HTML><HEAD></HEAD><BODY><P>Thanks Ashfaq, you've been a great help!</P></BODY></HTML> Wed, 13 Aug 2014 08:58:27 GMT 2014-08-13T08:58:27Z Year comparison https://community.qlik.com/t5/QlikView/Year-comparison/m-p/670233#M243551 <HTML><HEAD></HEAD><BODY><P>Hi guys!</P><P></P><P>I would like to compare the results from the months of the selected year with the previous year.</P><P>Is this possible?</P><P></P><P>I added some more information in the attached document.</P><P></P><P>Kind regards,</P><P>Katleen</P><P></P><P>Het bericht is bewerkt door: Katleen Vercauteren</P></BODY></HTML> Wed, 13 Aug 2014 07:04:09 GMT https://community.qlik.com/t5/QlikView/Year-comparison/m-p/670233#M243551 2014-08-13T07:04:09Z Re: Year comparison https://community.qlik.com/t5/QlikView/Year-comparison/m-p/670234#M243552 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; There is no document attached. Kindly attach again, also give some example of your problem.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 13 Aug 2014 07:07:29 GMT https://community.qlik.com/t5/QlikView/Year-comparison/m-p/670234#M243552 kaushiknsolanki 2014-08-13T07:07:29Z Re: Year comparison https://community.qlik.com/t5/QlikView/Year-comparison/m-p/670235#M243553 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try below</P><P></P><P><STRONG>Current Year Sales</STRONG></P><P>=Sum({&lt;Year = {'$(=Max(Year))'}&gt;} Sales)</P><P></P><P><STRONG> Previous Year Sales</STRONG></P><P> =Sum({&lt;Year = {'$(=Max(Year)-1)'}&gt;} Sales)</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 13 Aug 2014 07:08:43 GMT https://community.qlik.com/t5/QlikView/Year-comparison/m-p/670235#M243553 ashfaq_haseeb 2014-08-13T07:08:43Z Re: Year comparison https://community.qlik.com/t5/QlikView/Year-comparison/m-p/670236#M243554 <HTML><HEAD></HEAD><BODY><P>Thanks Ashfaq, you've been a great help!</P></BODY></HTML> Wed, 13 Aug 2014 08:58:27 GMT https://community.qlik.com/t5/QlikView/Year-comparison/m-p/670236#M243554 2014-08-13T08:58:27Z