Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
joshrussin
Creator III
Creator III

Line graph showing days in month

Hey everyone,

I am trying to make a graph that shows how many workdays are in a month per month.

This is the formula I am using to find workdays in month.

=NetWorkDays(MonthStart(Max(Date)), MonthEnd(Max(Date)), $(vHolidays))

when I put it into the graph it only shows the value for the current month into all months. I tried without Max and then the line just disappears.

test.jpg

1 Solution

Accepted Solutions
joshrussin
Creator III
Creator III
Author

After looking at this a little closer, I was able to figure out I was using the wrong "Date" in the expression. The correct formula for this was...

=NetWorkDays(MonthStart(Max(Date_Dash)), MonthEnd(Max(Date_Dash)), $(vHolidays))

View solution in original post

1 Reply
joshrussin
Creator III
Creator III
Author

After looking at this a little closer, I was able to figure out I was using the wrong "Date" in the expression. The correct formula for this was...

=NetWorkDays(MonthStart(Max(Date_Dash)), MonthEnd(Max(Date_Dash)), $(vHolidays))