topic Days count from today in QlikView https://community.qlik.com/t5/QlikView/Days-count-from-today/m-p/322709#M1197031 <HTML><HEAD></HEAD><BODY><P>OMG it works</P><P></P><P></P><P></P><P>=</P><P>'Number of Days selected '&amp;<B>num</B>(<B>if</B>(<B>max</B>(<B>Date</B>)&gt;<B>today</B>(-1),<B>NetWorkDays</B>(<B>min</B>(<B>Date</B>),<B>today</B>(-1)),<B>NetWorkDays</B>(<B>min</B>(<B>Date</B>),<B>max</B>(<B>Date</B>))))</P><P>Thanks</P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 19 Apr 2011 12:16:01 GMT 2011-04-19T12:16:01Z Days count from today https://community.qlik.com/t5/QlikView/Days-count-from-today/m-p/322707#M1197029 <HTML><HEAD></HEAD><BODY><P></P><P>=</P><P>'Number of Days selected '&amp;<B>num</B>(<B>NetWorkDays</B>(<B>min</B>(<B>Date</B>),<B>max</B>(<B>Date</B>)))</P><P></P><P>Hi Guys</P><P>I have a text box to cout the number of working days selected, however I have data loaded in to forcast . What the above formula is doing is counting all dates, it works when specific dates are selected, but when nothing is , it is counting all available dates including dates in the future.</P><P>Is it possible to change it so it counts the selected dates , and defaults at number of days in the past until today -1</P><P>Please help !!!!<BR />Thanks</P><BR /><BR /></BODY></HTML> Tue, 19 Apr 2011 10:56:03 GMT https://community.qlik.com/t5/QlikView/Days-count-from-today/m-p/322707#M1197029 2011-04-19T10:56:03Z Days count from today https://community.qlik.com/t5/QlikView/Days-count-from-today/m-p/322708#M1197030 <HTML><HEAD></HEAD><BODY><P>Look to place an 'IF' in there based around '&lt;today()'. to limit the dates the expression is looking at.</P><P>All the best,</P><P>Matt - Visual Analytics Ltd</P></BODY></HTML> Tue, 19 Apr 2011 11:16:26 GMT https://community.qlik.com/t5/QlikView/Days-count-from-today/m-p/322708#M1197030 matt_crowther 2011-04-19T11:16:26Z Days count from today https://community.qlik.com/t5/QlikView/Days-count-from-today/m-p/322709#M1197031 <HTML><HEAD></HEAD><BODY><P>OMG it works</P><P></P><P></P><P></P><P>=</P><P>'Number of Days selected '&amp;<B>num</B>(<B>if</B>(<B>max</B>(<B>Date</B>)&gt;<B>today</B>(-1),<B>NetWorkDays</B>(<B>min</B>(<B>Date</B>),<B>today</B>(-1)),<B>NetWorkDays</B>(<B>min</B>(<B>Date</B>),<B>max</B>(<B>Date</B>))))</P><P>Thanks</P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 19 Apr 2011 12:16:01 GMT https://community.qlik.com/t5/QlikView/Days-count-from-today/m-p/322709#M1197031 2011-04-19T12:16:01Z Days count from today https://community.qlik.com/t5/QlikView/Days-count-from-today/m-p/322710#M1197032 <HTML><HEAD></HEAD><BODY><P>OMG it works</P><P></P><P></P><P></P><P>=</P><P>'Number of Days selected '&amp;<B>num</B>(<B>if</B>(<B>max</B>(<B>Date</B>)&gt;<B>today</B>(-1),<B>NetWorkDays</B>(<B>min</B>(<B>Date</B>),<B>today</B>(-1)),<B>NetWorkDays</B>(<B>min</B>(<B>Date</B>),<B>max</B>(<B>Date</B>))))</P><P>Thanks</P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 19 Apr 2011 12:16:03 GMT https://community.qlik.com/t5/QlikView/Days-count-from-today/m-p/322710#M1197032 2011-04-19T12:16:03Z