topic Re: Network Days Nulls! in QlikView https://community.qlik.com/t5/QlikView/Network-Days-Nulls/m-p/410640#M1155602 <HTML><HEAD></HEAD><BODY><P>Make sure both dates are real dates and not strings. 18/12/2012 might be evaluated as 18 divided by 12 divided by 2012. Use the date# function if necesary.</P><P>Also you're comparing with strings: &gt;'0' and &lt;='4'. Try using the numbers 0 and 4 instead of strings.</P></BODY></HTML> Wed, 06 Feb 2013 17:37:06 GMT Gysbert_Wassenaar 2013-02-06T17:37:06Z Network Days Nulls! https://community.qlik.com/t5/QlikView/Network-Days-Nulls/m-p/410639#M1155601 <HTML><HEAD></HEAD><BODY><P>Hello I am using an expression :-<SPAN style="color: #0000ff; font-size: 8pt;">if<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NetWorkDays</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">BA_Contact_Date</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Posting_Date</SPAN><SPAN style="font-size: 8pt;">)&gt;'0' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NetWorkDays</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">BA_Contact_Date</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Posting_Date</SPAN><SPAN style="font-size: 8pt;">)&lt;='4',</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">money</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Sum Paid]</SPAN></SPAN><SPAN style="font-size: 8pt;">*-1)) which works fine for the most part but for some reason it is returning Nulls!</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">So I then as an experiment added another expression </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>NetWorkDays<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">BA_Contact_Date</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Posting_Date</SPAN><SPAN style="color: #000000; font-size: 8pt;">)&nbsp; which also returned a null. The BA_Contact_date ='18/12/2012' and the Posting_Date is 18/12/2012. </SPAN></P><P></P><P><SPAN style="color: #000000;">I dont understand why Network days is returning Nulls for perfectly valid dates.</SPAN></P><P></P><P><SPAN style="color: #000000;">Any ideas?</SPAN></P><P></P><P><SPAN style="color: #000000;">Paul.</SPAN></P><P></P></BODY></HTML> Wed, 06 Feb 2013 16:18:14 GMT https://community.qlik.com/t5/QlikView/Network-Days-Nulls/m-p/410639#M1155601 2013-02-06T16:18:14Z Re: Network Days Nulls! https://community.qlik.com/t5/QlikView/Network-Days-Nulls/m-p/410640#M1155602 <HTML><HEAD></HEAD><BODY><P>Make sure both dates are real dates and not strings. 18/12/2012 might be evaluated as 18 divided by 12 divided by 2012. Use the date# function if necesary.</P><P>Also you're comparing with strings: &gt;'0' and &lt;='4'. Try using the numbers 0 and 4 instead of strings.</P></BODY></HTML> Wed, 06 Feb 2013 17:37:06 GMT https://community.qlik.com/t5/QlikView/Network-Days-Nulls/m-p/410640#M1155602 Gysbert_Wassenaar 2013-02-06T17:37:06Z