topic Re: Apples with Apples in QlikView https://community.qlik.com/t5/QlikView/Apples-with-Apples/m-p/1342504#M832932 <HTML><HEAD></HEAD><BODY><P>That gave me the total of both years</P></BODY></HTML> Fri, 09 Jun 2017 11:05:18 GMT Anonymous 2017-06-09T11:05:18Z Apples with Apples https://community.qlik.com/t5/QlikView/Apples-with-Apples/m-p/1342502#M832930 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data in the below format.&nbsp; What i would like to do, is compare 2012's data with the same months in 2011.</P><P></P><P>How can this be done?</P><P></P><P><IMG alt="Qestion.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166335_Qestion.PNG" style="height: auto;" /></P><P>This should allow , that when November's value is added, that the aggregated total will include the nov and then compare it to the same amount of months in the previous year.</P><P></P><P>Thanks in advance !</P><P></P><P>Regards,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Apples-with-Apples/m-p/1342502#M832930 Anonymous 2020-11-25T16:16:04Z Re: Apples with Apples https://community.qlik.com/t5/QlikView/Apples-with-Apples/m-p/1342503#M832931 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>If(Sum(TOTAL &lt;Month&gt; {&lt;Year = {$(=Max(Year))}&gt;}Sales) &gt; 0, Sum(Sales))</STRONG></P></BODY></HTML> Fri, 09 Jun 2017 09:48:44 GMT https://community.qlik.com/t5/QlikView/Apples-with-Apples/m-p/1342503#M832931 sunny_talwar 2017-06-09T09:48:44Z Re: Apples with Apples https://community.qlik.com/t5/QlikView/Apples-with-Apples/m-p/1342504#M832932 <HTML><HEAD></HEAD><BODY><P>That gave me the total of both years</P></BODY></HTML> Fri, 09 Jun 2017 11:05:18 GMT https://community.qlik.com/t5/QlikView/Apples-with-Apples/m-p/1342504#M832932 Anonymous 2017-06-09T11:05:18Z Re: Apples with Apples https://community.qlik.com/t5/QlikView/Apples-with-Apples/m-p/1342505#M832933 <HTML><HEAD></HEAD><BODY><P>Really? Can you share a sample where it did that? That is so strange....</P></BODY></HTML> Fri, 09 Jun 2017 11:15:51 GMT https://community.qlik.com/t5/QlikView/Apples-with-Apples/m-p/1342505#M832933 sunny_talwar 2017-06-09T11:15:51Z Re: Apples with Apples https://community.qlik.com/t5/QlikView/Apples-with-Apples/m-p/1342506#M832934 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>do you want your Comparison&nbsp; to be added as a new Expression? Or just a total</P><P>And do you want the object to be a Pivot table or a straight table ?</P></BODY></HTML> Fri, 09 Jun 2017 11:54:15 GMT https://community.qlik.com/t5/QlikView/Apples-with-Apples/m-p/1342506#M832934 philipp_ebner 2017-06-09T11:54:15Z