topic Summing values from Current date to a variable amount in the future in QlikView https://community.qlik.com/t5/QlikView/Summing-values-from-Current-date-to-a-variable-amount-in-the/m-p/380939#M142118 <HTML><HEAD></HEAD><BODY><P style="margin: 0.0px 0.0px 0.0px 0.0px; color: #9b1108;">I am trying to sum the values from the start of the current week to a variabe date in the future that has values.&nbsp; If I put a specific date in the future, I get a return value.&nbsp; If I try to take todays date and add 7 or 14 to it or a variavbe input, I get nothing returned.</P><P></P><P style="margin: 0.0px 0.0px 0.0px 0.0px; color: #9b1108;"><SPAN style="color: #000000;">=</SPAN><SPAN style="color: #002efa;">sum</SPAN><SPAN style="color: #000000;">({$&lt;</SPAN>Gross_Forecast_Week<SPAN style="color: #000000;"> = {</SPAN>"&gt;=(weekstart(Today())&lt;=(weekstart(Today()+ vWeeks)"<SPAN style="color: #000000;">}, </SPAN>Gross_File_Week<SPAN style="color: #000000;">={'$(=Max(weekstart(Gross_File_Week)))'}&gt;} </SPAN>Gross_Forecast_Quantity<SPAN style="color: #000000;">/(8*4) ) </SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P></BODY></HTML> Sat, 25 Aug 2012 16:27:32 GMT 2012-08-25T16:27:32Z Summing values from Current date to a variable amount in the future https://community.qlik.com/t5/QlikView/Summing-values-from-Current-date-to-a-variable-amount-in-the/m-p/380939#M142118 <HTML><HEAD></HEAD><BODY><P style="margin: 0.0px 0.0px 0.0px 0.0px; color: #9b1108;">I am trying to sum the values from the start of the current week to a variabe date in the future that has values.&nbsp; If I put a specific date in the future, I get a return value.&nbsp; If I try to take todays date and add 7 or 14 to it or a variavbe input, I get nothing returned.</P><P></P><P style="margin: 0.0px 0.0px 0.0px 0.0px; color: #9b1108;"><SPAN style="color: #000000;">=</SPAN><SPAN style="color: #002efa;">sum</SPAN><SPAN style="color: #000000;">({$&lt;</SPAN>Gross_Forecast_Week<SPAN style="color: #000000;"> = {</SPAN>"&gt;=(weekstart(Today())&lt;=(weekstart(Today()+ vWeeks)"<SPAN style="color: #000000;">}, </SPAN>Gross_File_Week<SPAN style="color: #000000;">={'$(=Max(weekstart(Gross_File_Week)))'}&gt;} </SPAN>Gross_Forecast_Quantity<SPAN style="color: #000000;">/(8*4) ) </SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P></BODY></HTML> Sat, 25 Aug 2012 16:27:32 GMT https://community.qlik.com/t5/QlikView/Summing-values-from-Current-date-to-a-variable-amount-in-the/m-p/380939#M142118 2012-08-25T16:27:32Z Re: Summing values from Current date to a variable amount in the future https://community.qlik.com/t5/QlikView/Summing-values-from-Current-date-to-a-variable-amount-in-the/m-p/380940#M142119 <HTML><HEAD></HEAD><BODY><P>Probably the numeric format is the problem...</P><P></P><P>Could you send the app?</P></BODY></HTML> Sat, 25 Aug 2012 22:00:51 GMT https://community.qlik.com/t5/QlikView/Summing-values-from-Current-date-to-a-variable-amount-in-the/m-p/380940#M142119 sebastiandperei 2012-08-25T22:00:51Z