topic Re: Network Days set analysis not working in QlikView https://community.qlik.com/t5/QlikView/Network-Days-set-analysis-not-working/m-p/1066024#M945288 <HTML><HEAD></HEAD><BODY><P>usually this happen when exists problem relationation, check if exists values null or duplicate, probably in the Place some value is null..</P></BODY></HTML> Mon, 11 Jan 2016 18:45:41 GMT 2016-01-11T18:45:41Z Network Days set analysis not working https://community.qlik.com/t5/QlikView/Network-Days-set-analysis-not-working/m-p/1066023#M945287 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a chart with the following settings:</P><P></P><P>Dimension:</P><P>Place (legend)</P><P>MonthYear (x-axis)</P><P></P><P>Expression: Count(Place)/$(vBusDays)</P><P></P><P>$(vBusDays) is <SPAN style="color: #0000ff; font-size: 8pt;">NetWorkDays</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Min</SPAN><SPAN style="font-size: 8pt;">({1&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">MonthYear</SPAN><SPAN style="font-size: 8pt;">=&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Max</SPAN><SPAN style="font-size: 8pt;">({1&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">MonthYear</SPAN><SPAN style="font-size: 8pt;">=&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P><P>This works fine in my pivot table if I remove Place as my dimension and just keep MonthYear, then it shows the correct expression, however when I include both place and monthyear the data is incorrect.</P><P></P><P>For example for January 2015, it should divide Count(Place) by 22, instead when I have Place and MonthYear as my dimensions, it divides Count(Place) by 21, why is this happening? Even though I have used set analysis for networkdays!!</P></BODY></HTML> Mon, 11 Jan 2016 18:24:06 GMT https://community.qlik.com/t5/QlikView/Network-Days-set-analysis-not-working/m-p/1066023#M945287 stjernvd 2016-01-11T18:24:06Z Re: Network Days set analysis not working https://community.qlik.com/t5/QlikView/Network-Days-set-analysis-not-working/m-p/1066024#M945288 <HTML><HEAD></HEAD><BODY><P>usually this happen when exists problem relationation, check if exists values null or duplicate, probably in the Place some value is null..</P></BODY></HTML> Mon, 11 Jan 2016 18:45:41 GMT https://community.qlik.com/t5/QlikView/Network-Days-set-analysis-not-working/m-p/1066024#M945288 2016-01-11T18:45:41Z Re: Network Days set analysis not working https://community.qlik.com/t5/QlikView/Network-Days-set-analysis-not-working/m-p/1066025#M945289 <HTML><HEAD></HEAD><BODY><P>I think it is right when it divide by 21...</P><P>In Jan 2015 has 21 work days...</P></BODY></HTML> Mon, 11 Jan 2016 19:11:40 GMT https://community.qlik.com/t5/QlikView/Network-Days-set-analysis-not-working/m-p/1066025#M945289 2016-01-11T19:11:40Z Re: Network Days set analysis not working https://community.qlik.com/t5/QlikView/Network-Days-set-analysis-not-working/m-p/1066026#M945290 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample to look at?</P></BODY></HTML> Mon, 11 Jan 2016 19:14:40 GMT https://community.qlik.com/t5/QlikView/Network-Days-set-analysis-not-working/m-p/1066026#M945290 sunny_talwar 2016-01-11T19:14:40Z