topic Date Comparison, Difference of Days in QlikView https://community.qlik.com/t5/QlikView/Date-Comparison-Difference-of-Days/m-p/291387#M108162 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I need to add a filter for my dashboard that will display items that have shipped [Invoice Date] before they were due [Due Date]. My expression is this:</P><P></P><P></P><P></P><P></P><P>=if ([IN Invoice Date]&lt;[CO Due Date] and&nbsp; NetWorkDays([CO Due Date],[IN Invoice Date] &lt;= 10)&nbsp; and (NetWorkDays([CO Due Date],[IN Invoice Date] &gt;= 0)), NetWorkDays([CO Due Date],[IN Invoice Date]))</P><P></P><P></P><P></P><P></P><P>This expression displays numbers 1-10 in my filter, but the data does not react to the filter. For example, when 1 is chosen, many orders still show up with more than one working day between the invoice date and the due date. My logic seems sounds and I'm not sure where to proceed from here. Any help would be appreciated. </P><P></P><P></P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P></P><P><A></A></P></BODY></HTML> Wed, 15 Jun 2011 17:08:24 GMT 2011-06-15T17:08:24Z Date Comparison, Difference of Days https://community.qlik.com/t5/QlikView/Date-Comparison-Difference-of-Days/m-p/291387#M108162 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I need to add a filter for my dashboard that will display items that have shipped [Invoice Date] before they were due [Due Date]. My expression is this:</P><P></P><P></P><P></P><P></P><P>=if ([IN Invoice Date]&lt;[CO Due Date] and&nbsp; NetWorkDays([CO Due Date],[IN Invoice Date] &lt;= 10)&nbsp; and (NetWorkDays([CO Due Date],[IN Invoice Date] &gt;= 0)), NetWorkDays([CO Due Date],[IN Invoice Date]))</P><P></P><P></P><P></P><P></P><P>This expression displays numbers 1-10 in my filter, but the data does not react to the filter. For example, when 1 is chosen, many orders still show up with more than one working day between the invoice date and the due date. My logic seems sounds and I'm not sure where to proceed from here. Any help would be appreciated. </P><P></P><P></P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P></P><P><A></A></P></BODY></HTML> Wed, 15 Jun 2011 17:08:24 GMT https://community.qlik.com/t5/QlikView/Date-Comparison-Difference-of-Days/m-p/291387#M108162 2011-06-15T17:08:24Z Date Comparison, Difference of Days https://community.qlik.com/t5/QlikView/Date-Comparison-Difference-of-Days/m-p/291388#M108163 <HTML><HEAD></HEAD><BODY><P>I would just add a field in the script that showed the difference between the two and you can just make selections that way.&nbsp; I don't really know why your method isn't working...</P></BODY></HTML> Wed, 15 Jun 2011 20:49:55 GMT https://community.qlik.com/t5/QlikView/Date-Comparison-Difference-of-Days/m-p/291388#M108163 2011-06-15T20:49:55Z