Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

wgonzalez
Contributor

Results by Category and Month: calculation of working days per month.

Hi,

I've created a bar chart showing %'s by month in each category.  I need to compute working days for each month as part of the % calculation.  The current expression (below) is calculating working days by the whole user selected time frame, not by each month.  Please advise.

 

sum(AttHours) / (((sum({$}EmpRecordCtr)*8) * NetWorkDays(MonthStart(min(DTPunchDate)),MonthEnd(max(DTPunchDate))))-sum(AttHours))

Capture.JPG

2 Replies
Not applicable

Re: Results by Category and Month: calculation of working days per month.

im not sure what you got inside the chart

post sample file

wgonzalez
Contributor

Re: Results by Category and Month: calculation of working days per month.

Here you go!  Each bar represents Hours Used % per month in each category.

To calculate the % I need to first calculate working days per month.  With the current formula (expression) I'm getting working days for the whole time frame selected by the user.

Thanks.

Capture.JPG