topic Re: Rolling 5 days sum in QlikView https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412291#M817709 <HTML><HEAD></HEAD><BODY><P>Yes Antonio,but each date may have multiple values.</P></BODY></HTML> Thu, 31 Aug 2017 09:21:56 GMT Anonymous 2017-08-31T09:21:56Z Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412287#M817705 <HTML><HEAD></HEAD><BODY><P>I have a date field and I want the sum of value for past 5 days for each day in a rolling fashion.each date has multiple values.</P><P>I tried using&nbsp; sum({1&lt;DATE = {"&gt;=$(=(Only(CdDate)-5)) &lt;$(=Only(CdDate))"}&gt;}[value])</P><P>but so far no luck.Please help</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412287#M817705 Anonymous 2020-11-25T16:16:04Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412288#M817706 <HTML><HEAD></HEAD><BODY><P>Hi Avinash,</P><P>like this ?</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/175211_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 31 Aug 2017 09:05:55 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412288#M817706 antoniotiman 2017-08-31T09:05:55Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412289#M817707 <HTML><HEAD></HEAD><BODY><P>Please check if the attached file serves the purpose</P></BODY></HTML> Thu, 31 Aug 2017 09:17:29 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412289#M817707 anushree1 2017-08-31T09:17:29Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412290#M817708 <HTML><HEAD></HEAD><BODY><P>Sorry Missed the attachment</P></BODY></HTML> Thu, 31 Aug 2017 09:18:27 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412290#M817708 anushree1 2017-08-31T09:18:27Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412291#M817709 <HTML><HEAD></HEAD><BODY><P>Yes Antonio,but each date may have multiple values.</P></BODY></HTML> Thu, 31 Aug 2017 09:21:56 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412291#M817709 Anonymous 2017-08-31T09:21:56Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412292#M817710 <HTML><HEAD></HEAD><BODY><P>Please share </P></BODY></HTML> Thu, 31 Aug 2017 09:23:35 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412292#M817710 Anonymous 2017-08-31T09:23:35Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412293#M817711 <HTML><HEAD></HEAD><BODY><P>I have attached the file is there any issues accessing it.</P></BODY></HTML> Thu, 31 Aug 2017 11:14:18 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412293#M817711 anushree1 2017-08-31T11:14:18Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412294#M817712 <HTML><HEAD></HEAD><BODY><P>What is the expected result ?</P></BODY></HTML> Thu, 31 Aug 2017 11:42:46 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412294#M817712 antoniotiman 2017-08-31T11:42:46Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412295#M817713 <HTML><HEAD></HEAD><BODY><P>Plz see the attached file.</P></BODY></HTML> Mon, 04 Sep 2017 05:13:06 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412295#M817713 Anonymous 2017-09-04T05:13:06Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412296#M817714 <HTML><HEAD></HEAD><BODY><P>Actually I cant access the qvw file inside qlik sense.</P></BODY></HTML> Mon, 04 Sep 2017 05:13:57 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412296#M817714 Anonymous 2017-09-04T05:13:57Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412297#M817715 <HTML><HEAD></HEAD><BODY><P>See Attachment.</P></BODY></HTML> Mon, 04 Sep 2017 18:16:05 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412297#M817715 antoniotiman 2017-09-04T18:16:05Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412298#M817716 <HTML><HEAD></HEAD><BODY><P>Would you please share your expression since qvw file is not accessible in Qlik sense</P></BODY></HTML> Tue, 05 Sep 2017 06:36:46 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412298#M817716 Anonymous 2017-09-05T06:36:46Z Re: Rolling 5 days sum https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412299#M817717 <HTML><HEAD></HEAD><BODY><P>See Attachment</P></BODY></HTML> Tue, 05 Sep 2017 07:00:40 GMT https://community.qlik.com/t5/QlikView/Rolling-5-days-sum/m-p/1412299#M817717 antoniotiman 2017-09-05T07:00:40Z