topic Re: Aggr Table in QlikView https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396147#M816515 <HTML><HEAD></HEAD><BODY><P>For you again</P></BODY></HTML> Tue, 12 Sep 2017 08:48:14 GMT Anil_Babu_Samineni 2017-09-12T08:48:14Z Aggr Table https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396141#M816509 <HTML><HEAD></HEAD><BODY><P>Good Day,</P><P></P><P>I need to replicate something like the below:</P><P><IMG alt="2.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176216_2.PNG" style="height: auto;" /></P><P>The stock on hand for the business on only calculated at this point in time. What I need to do is do a forecast&nbsp; for the next few days.&nbsp; That does not necessarily have to be user selected, I can hardcode this part as it will always be for the next 4 to 5 days.</P><P></P><P>There will almost always also be orders done for future dates.&nbsp; All i need to do, is take the SOH - OrderQTY for the day which would be the opening amount for the future date etc.</P><P></P><P>Using AGGR comes to mind, im just not too sure how to go about doing this.&nbsp; Any help would be greatly appreciated !</P><P></P><P>Kind regards,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396141#M816509 Anonymous 2020-11-25T16:16:04Z Re: Aggr Table https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396142#M816510 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Tue, 12 Sep 2017 08:28:37 GMT https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396142#M816510 Anil_Babu_Samineni 2017-09-12T08:28:37Z Re: Aggr Table https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396143#M816511 <HTML><HEAD></HEAD><BODY><P>PFA?</P></BODY></HTML> Tue, 12 Sep 2017 08:32:35 GMT https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396143#M816511 Anonymous 2017-09-12T08:32:35Z Re: Aggr Table https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396144#M816512 <HTML><HEAD></HEAD><BODY><P>Please Find Attachment <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 12 Sep 2017 08:34:05 GMT https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396144#M816512 Anil_Babu_Samineni 2017-09-12T08:34:05Z Re: Aggr Table https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396145#M816513 <HTML><HEAD></HEAD><BODY><P>I dont see any attachments. Please try again.</P></BODY></HTML> Tue, 12 Sep 2017 08:37:17 GMT https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396145#M816513 Anonymous 2017-09-12T08:37:17Z Re: Aggr Table https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396146#M816514 <HTML><HEAD></HEAD><BODY><P>Hi Ruan,</P><P></P><P>Please use the below expression.</P><P></P><P>=Aggr(Sum(SOH-OrderQTY),Available,Date)</P><P></P><P>Many Thanks</P><P>Karthik</P></BODY></HTML> Tue, 12 Sep 2017 08:38:13 GMT https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396146#M816514 karthikoffi27se 2017-09-12T08:38:13Z Re: Aggr Table https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396147#M816515 <HTML><HEAD></HEAD><BODY><P>For you again</P></BODY></HTML> Tue, 12 Sep 2017 08:48:14 GMT https://community.qlik.com/t5/QlikView/Aggr-Table/m-p/1396147#M816515 Anil_Babu_Samineni 2017-09-12T08:48:14Z