topic Re: How to calculate in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1259712#M397521 <HTML><HEAD></HEAD><BODY><P>May be you need to use <A href="https://community.qlik.com/qlik-blogpost/4531">The As-Of Table</A></P></BODY></HTML> Wed, 14 Dec 2016 10:52:05 GMT sunny_talwar 2016-12-14T10:52:05Z How to calculate https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1259711#M397520 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a chart that has the dimension YYYY-MM and one of the columns is Avg.</P><P>In the last column would I like to show Avg the same month last yearbut I cannot</P><P>get it working. What have</P><P> I done wrong?</P><P><IMG alt="AvgLY.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/146599_AvgLY.png" style="height: auto;" /></P><P>Here is the calcultaion I try.</P><P><IMG alt="AvgLY_Calc.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/146606_AvgLY_Calc.png" style="width: 620px; height: 122px;" /></P><P></P><P>kindly</P><P>Håkan</P></BODY></HTML> Wed, 14 Dec 2016 10:37:56 GMT https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1259711#M397520 2016-12-14T10:37:56Z Re: How to calculate https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1259712#M397521 <HTML><HEAD></HEAD><BODY><P>May be you need to use <A href="https://community.qlik.com/qlik-blogpost/4531">The As-Of Table</A></P></BODY></HTML> Wed, 14 Dec 2016 10:52:05 GMT https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1259712#M397521 sunny_talwar 2016-12-14T10:52:05Z Re: How to calculate https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1259713#M397522 <HTML><HEAD></HEAD><BODY><P>Try like this in Set for PeriodID,</P><P></P><P><STRONG>PeriodID = {"$(=Max(PeriodID)-11)"}</STRONG></P><P></P><P></P></BODY></HTML> Wed, 14 Dec 2016 10:53:58 GMT https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1259713#M397522 ganeshsvm 2016-12-14T10:53:58Z Re: How to calculate https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1259714#M397523 <HTML><HEAD></HEAD><BODY><P><STRONG>sum( {&lt;periodid={"$(=AddYears(Month(PeriodID),-1))"}&gt;} $(vnettofors)/$(vnettoant) )</STRONG></P></BODY></HTML> Wed, 14 Dec 2016 11:02:17 GMT https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1259714#M397523 Anonymous 2016-12-14T11:02:17Z Re: How to calculate https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1259715#M397524 <HTML><HEAD></HEAD><BODY><P>I found a link to Above() in your suggestion and this solved it.</P><P><A href="https://community.qlik.com/qlik-blogpost/4522">The Above Function</A></P></BODY></HTML> Wed, 14 Dec 2016 12:47:56 GMT https://community.qlik.com/t5/QlikView/How-to-calculate/m-p/1259715#M397524 2016-12-14T12:47:56Z