Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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))