topic Re: Query on variance in QlikView https://community.qlik.com/t5/QlikView/Query-on-variance/m-p/610973#M225504 <HTML><HEAD></HEAD><BODY><P><IMG alt="Var.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/56769_Var.png" style="width: 620px; height: 174px;" /></P></BODY></HTML> Tue, 08 Apr 2014 04:42:49 GMT 2014-04-08T04:42:49Z Query on variance https://community.qlik.com/t5/QlikView/Query-on-variance/m-p/610972#M225503 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Have a small issue&nbsp; on variance...let me know the set analysis code for the foll formula....</P><P></P><P>[ (Actual '13 - Actual '12) / Actual '12&nbsp; ] * 100</P><P></P><P>I have applied</P><P></P><P>sum({$&lt;YEAR= {$(=max(YEAR-1))}&gt;}CTS-----(VVALUE13)</P><P></P><P>sum({$&lt;YEAR= {$(=max(YEAR))}&gt;}CTS----(VVALUE14)</P><P></P><P>Created Variable</P><P></P><P>=(((VVALUE14)-(VVALUE13))/VVALUE13)*100</P><P></P><P>On month and year selection i am getting the right value...but on summary level it is showing same values....</P><P></P><P>let me know the reson y it is showing same values....like -89......on selection i m getting wite vale...plz help me</P></BODY></HTML> Tue, 08 Apr 2014 04:42:12 GMT https://community.qlik.com/t5/QlikView/Query-on-variance/m-p/610972#M225503 2014-04-08T04:42:12Z Re: Query on variance https://community.qlik.com/t5/QlikView/Query-on-variance/m-p/610973#M225504 <HTML><HEAD></HEAD><BODY><P><IMG alt="Var.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/56769_Var.png" style="width: 620px; height: 174px;" /></P></BODY></HTML> Tue, 08 Apr 2014 04:42:49 GMT https://community.qlik.com/t5/QlikView/Query-on-variance/m-p/610973#M225504 2014-04-08T04:42:49Z