topic Re: Compare date range in QlikView https://community.qlik.com/t5/QlikView/Compare-date-range/m-p/978681#M334274 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=RangeSum(Above(Sum(Imp), 0, 5)) - RangeSum(Above(Sum(Imp), 5, 5))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG __jive_id="102017" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/102017_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Wed, 14 Oct 2015 13:53:53 GMT sunny_talwar 2015-10-14T13:53:53Z Compare date range https://community.qlik.com/t5/QlikView/Compare-date-range/m-p/978680#M334273 <HTML><HEAD></HEAD><BODY><P>In the attached example, I need to calculate for each day of the dimension five days back and compare them with five days previous to the first 5.</P><P>For example, for the day 30/09 day should add 30,29,28,27,26 / 09 and compare them with the days 25,24,23,22,21 / 09.</P><P>In the example there are more clarification.</P><P></P><P>Regards.</P></BODY></HTML> Wed, 14 Oct 2015 13:49:49 GMT https://community.qlik.com/t5/QlikView/Compare-date-range/m-p/978680#M334273 spividori 2015-10-14T13:49:49Z Re: Compare date range https://community.qlik.com/t5/QlikView/Compare-date-range/m-p/978681#M334274 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=RangeSum(Above(Sum(Imp), 0, 5)) - RangeSum(Above(Sum(Imp), 5, 5))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG __jive_id="102017" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/102017_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Wed, 14 Oct 2015 13:53:53 GMT https://community.qlik.com/t5/QlikView/Compare-date-range/m-p/978681#M334274 sunny_talwar 2015-10-14T13:53:53Z