Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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) )


1 Reply
sebastiandperei
Specialist
Specialist

Probably the numeric format is the problem...

Could you send the app?