topic Re: Line graph showing days in month in QlikView https://community.qlik.com/t5/QlikView/Line-graph-showing-days-in-month/m-p/1431777#M804924 <HTML><HEAD></HEAD><BODY><P>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...</P><P></P><P>=NetWorkDays(MonthStart(Max(Date_Dash)), MonthEnd(Max(Date_Dash)), $(vHolidays))</P></BODY></HTML> Tue, 07 Nov 2017 19:03:28 GMT joshrussin 2017-11-07T19:03:28Z Line graph showing days in month https://community.qlik.com/t5/QlikView/Line-graph-showing-days-in-month/m-p/1431776#M804923 <HTML><HEAD></HEAD><BODY><P>Hey everyone, </P><P></P><P>I am trying to make a graph that shows how many workdays are in a month per month.</P><P></P><P>This is the formula I am using to find workdays in month.</P><P></P><P>=NetWorkDays(MonthStart(Max(Date)), MonthEnd(Max(Date)), $(vHolidays))</P><P></P><P>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. </P><P></P><P><IMG alt="test.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182425_test.jpg" style="height: 208px; width: 620px;" /> </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Line-graph-showing-days-in-month/m-p/1431776#M804923 joshrussin 2020-11-25T16:16:04Z Re: Line graph showing days in month https://community.qlik.com/t5/QlikView/Line-graph-showing-days-in-month/m-p/1431777#M804924 <HTML><HEAD></HEAD><BODY><P>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...</P><P></P><P>=NetWorkDays(MonthStart(Max(Date_Dash)), MonthEnd(Max(Date_Dash)), $(vHolidays))</P></BODY></HTML> Tue, 07 Nov 2017 19:03:28 GMT https://community.qlik.com/t5/QlikView/Line-graph-showing-days-in-month/m-p/1431777#M804924 joshrussin 2017-11-07T19:03:28Z