Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Announcements
Qlik Connect 2025! Where innovative solutions turn your data visions into reality: REGISTER TODAY

Who Me Too'd this solution

Not applicable
‎2012-06-21 11:11 AM

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

1 user say ditto
892 Views
0 Likes
Who Me Too'd this solution