QlikView App Dev

Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW

Who Me Too'd this solution

Not applicable

I ended up using the following after creating YearDay using the DayNumberOfYear expression in the load script:

= sum({<"YearDay" = {">=$(=max(YearDay)-4)<=$(=max(YearDay))"}>}[Actual Input Qty] - [Std Input Qty])

Thanks to those who responded.

View solution in original post

Who Me Too'd this solution