Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Tell us which business and trade publications you read most regularly: RESPOND NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Production per Business Days


Im looking to calculate the average production per day using networkdays for the current month. The data is cumulative of the current month only pulled weekly. End of week 1 would like to show the average total transaction for that week and so on. Thank you.

1 Reply
Contributor III
Contributor III

Hi @danieldors ,

Taking only what you said, maybe this can be close to what you may need (see attachment). If you can share some data sample, will be easier to understand and help you.

=Avg( Aggr( sum([Production]) / NetWorkDays(Min([DateProd]),Max([DateProd])), [WeekProd]) )


I hope to learn a lot here and help if I can