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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate Rolling Average When Data is missing

Is this example I using the above function to create a rolling average of sales over a 3 week period.  If I get a report of sales each week then everything works fine (That would be product A in the example).  My problem is for some inputs of if they don't have any sales for a product during a week they don't report a value at all (products B,C) in the example

Is there a different function to use or what have other folks used to handle this situation.

0 Replies