topic Re: Above Function Month over Month in QlikView https://community.qlik.com/t5/QlikView/Above-Function-Month-over-Month/m-p/1172576#M885725 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny!</P></BODY></HTML> Fri, 09 Sep 2016 16:15:07 GMT 2016-09-09T16:15:07Z Above Function Month over Month https://community.qlik.com/t5/QlikView/Above-Function-Month-over-Month/m-p/1172574#M885723 <HTML><HEAD></HEAD><BODY><P>Hello I am attempting to do month over month variance using the ABOVE function, but I run into the issue of my January's not using the December of the previous years. The formula is simply&nbsp; =NUM(Amt/ABOVE(Amt),'##.00%'). Any help would be appreciated.</P><P><IMG __jive_id="136904" alt="MoM.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/136904_MoM.PNG" style="height: auto; width: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Above-Function-Month-over-Month/m-p/1172574#M885723 2020-11-25T16:16:04Z Re: Above Function Month over Month https://community.qlik.com/t5/QlikView/Above-Function-Month-over-Month/m-p/1172575#M885724 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Num(Amt/Above(<SPAN style="color: #ff0000;">TOTAL</SPAN> Amt),'##.00%')</STRONG></SPAN></P></BODY></HTML> Thu, 08 Sep 2016 23:13:41 GMT https://community.qlik.com/t5/QlikView/Above-Function-Month-over-Month/m-p/1172575#M885724 sunny_talwar 2016-09-08T23:13:41Z Re: Above Function Month over Month https://community.qlik.com/t5/QlikView/Above-Function-Month-over-Month/m-p/1172576#M885725 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny!</P></BODY></HTML> Fri, 09 Sep 2016 16:15:07 GMT https://community.qlik.com/t5/QlikView/Above-Function-Month-over-Month/m-p/1172576#M885725 2016-09-09T16:15:07Z