topic Annual comparison in QlikView https://community.qlik.com/t5/QlikView/Annual-comparison/m-p/1362802#M837822 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i´m testing Qlik View so i do not really know how this tool works. My question is if there is a way to compare for example the sales from August 2016 to August 2015 and display it at once?</P><P><BR />If yes how to do that or is ther a manual who explains this?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Annual comparison https://community.qlik.com/t5/QlikView/Annual-comparison/m-p/1362802#M837822 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i´m testing Qlik View so i do not really know how this tool works. My question is if there is a way to compare for example the sales from August 2016 to August 2015 and display it at once?</P><P><BR />If yes how to do that or is ther a manual who explains this?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Annual-comparison/m-p/1362802#M837822 2020-11-25T16:16:04Z Re: Annual comparison https://community.qlik.com/t5/QlikView/Annual-comparison/m-p/1362803#M837823 <HTML><HEAD></HEAD><BODY><P>Yes, You need to create Tabular object wither Straight table or Pivot table or Chart may be Bar Chart</P><P>You have to create expressions like. I am assuming you have data till Aug 2016</P><P></P><P><STRONG>Sum({&lt;MonthYear = {'&gt;=$(=AddYears(Max(MonthYear),-1)) &lt;=$(=Max(MonthYear))'}&gt;}Sales)</STRONG></P></BODY></HTML> Wed, 17 May 2017 14:49:53 GMT https://community.qlik.com/t5/QlikView/Annual-comparison/m-p/1362803#M837823 Anil_Babu_Samineni 2017-05-17T14:49:53Z