topic Re: Flag Last 5 Working Days in QlikView https://community.qlik.com/t5/QlikView/Flag-Last-5-Working-Days/m-p/893140#M310999 <HTML><HEAD></HEAD><BODY><P>many thanks,</P><P></P><P>Works perfectly</P></BODY></HTML> Tue, 02 Jun 2015 08:45:32 GMT 2015-06-02T08:45:32Z Flag Last 5 Working Days https://community.qlik.com/t5/QlikView/Flag-Last-5-Working-Days/m-p/893137#M310996 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a field : actual_date </P><P></P><P>Is it possible when loading the data to set a flag against this date if it falls within the last 5 working days upto midnight of last night?</P><P></P><P>Eg</P><P></P><P>Data is reloaded at 7am on a Wednesday morning.&nbsp; I would need the 'Last 5 Days Flag' to cover </P><P></P><UL><LI>Wednesday</LI><LI>Thursday</LI><LI>Friday</LI><LI>Monday</LI><LI>Tuesday</LI></UL><P></P><P>Many thanks for you help</P><P>Tom</P></BODY></HTML> Tue, 02 Jun 2015 08:11:34 GMT https://community.qlik.com/t5/QlikView/Flag-Last-5-Working-Days/m-p/893137#M310996 2015-06-02T08:11:34Z Re: Flag Last 5 Working Days https://community.qlik.com/t5/QlikView/Flag-Last-5-Working-Days/m-p/893138#M310997 <HTML><HEAD></HEAD><BODY><P>Something like this perhaps:</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; actual_date,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; if( firstworkday(today()-1, 5) &lt;= actual_date and actual_date &lt; today(), 1, 0) as IsInLast5Days</P><P>FROM ...</P></BODY></HTML> Tue, 02 Jun 2015 08:18:19 GMT https://community.qlik.com/t5/QlikView/Flag-Last-5-Working-Days/m-p/893138#M310997 Gysbert_Wassenaar 2015-06-02T08:18:19Z Re: Flag Last 5 Working Days https://community.qlik.com/t5/QlikView/Flag-Last-5-Working-Days/m-p/893139#M310998 <HTML><HEAD></HEAD><BODY><P>In the load script add something like :</P><P></P><P>if ( [<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">actual_date] &gt; today() -5 , 1 , 0 )&nbsp;&nbsp;&nbsp;&nbsp; as [Last5DayFlag] ,</SPAN></P></BODY></HTML> Tue, 02 Jun 2015 08:18:51 GMT https://community.qlik.com/t5/QlikView/Flag-Last-5-Working-Days/m-p/893139#M310998 Anonymous 2015-06-02T08:18:51Z Re: Flag Last 5 Working Days https://community.qlik.com/t5/QlikView/Flag-Last-5-Working-Days/m-p/893140#M310999 <HTML><HEAD></HEAD><BODY><P>many thanks,</P><P></P><P>Works perfectly</P></BODY></HTML> Tue, 02 Jun 2015 08:45:32 GMT https://community.qlik.com/t5/QlikView/Flag-Last-5-Working-Days/m-p/893140#M310999 2015-06-02T08:45:32Z