Summing values from Current date to a variable amo... - Qlik Community

Report Inappropriate Content · ‎2012-08-25

I am trying to sum the values from the start of the current week to a variabe date in the future that has values. If I put a specific date in the future, I get a return value. If I try to take todays date and add 7 or 14 to it or a variavbe input, I get nothing returned.

=sum({$<Gross_Forecast_Week = {">=(weekstart(Today())<=(weekstart(Today()+ vWeeks)"}, Gross_File_Week={'$(=Max(weekstart(Gross_File_Week)))'}>} Gross_Forecast_Quantity/(8*4) )

sebastiandperei · ‎2012-08-25

Probably the numeric format is the problem...

Could you send the app?

Summing values from Current date to a variable amount in the future