topic Re: Comparative Analysis in QlikView https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/1020762#M924678 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Sum({[Group A] * $&lt;MonthDiff = {"&lt;12"}&gt;} Amount)</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum({[Group A] * $<SPAN style="color: #ff0000;">}*{$</SPAN>&lt;MonthDiff = {"&lt;12"}&gt;} Amount)</STRONG></P></BODY></HTML> Tue, 12 Apr 2016 18:11:38 GMT sunny_talwar 2016-04-12T18:11:38Z Comparative Analysis https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/1020761#M924677 <HTML><HEAD></HEAD><BODY><P>I have the following chart which i am using for comparative analysis of two groups namely Group A vs Group B:</P><P><IMG alt="Screen Shot 2016-04-12 at 19.30.22.png" class="jive-image image-1" src="/legacyfs/online/121413_Screen Shot 2016-04-12 at 19.30.22.png" style="height: auto;" /></P><P>The expressions for the two groups are as follows:</P><P><IMG alt="Screen Shot 2016-04-12 at 19.34.08.png" class="jive-image image-2" src="/legacyfs/online/121422_Screen Shot 2016-04-12 at 19.34.08.png" style="height: auto;" /></P><P><IMG alt="Screen Shot 2016-04-12 at 19.34.26.png" class="jive-image image-3" src="/legacyfs/online/121423_Screen Shot 2016-04-12 at 19.34.26.png" style="height: auto;" /></P><P>Now i want to use Moving Annual Totals instead of straight sum to do the comparisons.&nbsp; I have modified the two expressions to be as follows using the AsOfMonths set analysis:</P><P><IMG alt="Screen Shot 2016-04-12 at 19.35.49.png" class="image-4 jive-image" src="/legacyfs/online/121424_Screen Shot 2016-04-12 at 19.35.49.png" style="height: auto;" /></P><P><IMG alt="Screen Shot 2016-04-12 at 19.36.27.png" class="image-5 jive-image" src="/legacyfs/online/121425_Screen Shot 2016-04-12 at 19.36.27.png" style="height: auto;" /></P><P>Amount = ([MedAid Amount] + Shortfall)</P><P>However the comparative analysis does not work and i get the following graph:</P><P><IMG alt="Screen Shot 2016-04-12 at 19.30.47.png" class="jive-image image-6" src="/legacyfs/online/121426_Screen Shot 2016-04-12 at 19.30.47.png" style="height: auto;" /></P><P>The MAT values are for the whole data sets and not the respective groups and the two values for Group A and B are the same.&nbsp; How can i solve my problem.</P><P></P><P>Regards</P><P>Chris</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/1020761#M924677 Anonymous 2020-11-25T16:16:04Z Re: Comparative Analysis https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/1020762#M924678 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Sum({[Group A] * $&lt;MonthDiff = {"&lt;12"}&gt;} Amount)</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333px;">Sum({[Group A] * $<SPAN style="color: #ff0000;">}*{$</SPAN>&lt;MonthDiff = {"&lt;12"}&gt;} Amount)</STRONG></P></BODY></HTML> Tue, 12 Apr 2016 18:11:38 GMT https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/1020762#M924678 sunny_talwar 2016-04-12T18:11:38Z Re: Comparative Analysis https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/1020763#M924679 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny, i used the first expression and it is working</P><P></P><P>Regards</P></BODY></HTML> Tue, 12 Apr 2016 18:35:09 GMT https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/1020763#M924679 Anonymous 2016-04-12T18:35:09Z