topic last 5 working days in QlikView https://community.qlik.com/t5/QlikView/last-5-working-days/m-p/738885#M264070 <HTML><HEAD></HEAD><BODY><P>got a table with a field named creation_date</P><P>I want to select the values of creation_date that are the last 5 working days available via a macro</P><P>Please advise</P></BODY></HTML> Thu, 16 Oct 2014 13:09:28 GMT ali_hijazi 2014-10-16T13:09:28Z last 5 working days https://community.qlik.com/t5/QlikView/last-5-working-days/m-p/738885#M264070 <HTML><HEAD></HEAD><BODY><P>got a table with a field named creation_date</P><P>I want to select the values of creation_date that are the last 5 working days available via a macro</P><P>Please advise</P></BODY></HTML> Thu, 16 Oct 2014 13:09:28 GMT https://community.qlik.com/t5/QlikView/last-5-working-days/m-p/738885#M264070 ali_hijazi 2014-10-16T13:09:28Z Re: last 5 working days https://community.qlik.com/t5/QlikView/last-5-working-days/m-p/738886#M264071 <HTML><HEAD></HEAD><BODY><P>Hi Ali,</P><P></P><P>well, you can easily define a working day in your calendar (based on Weekday([date]))</P><P>=&gt; Using the PEEK() or PREVIOUS() functions you can (in the script) look into the last 5 records and check whether those are the last 5 working days - if so, there is data for the last 5 working_days.</P><P>HTH</P><P></P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Thu, 16 Oct 2014 13:21:33 GMT https://community.qlik.com/t5/QlikView/last-5-working-days/m-p/738886#M264071 datanibbler 2014-10-16T13:21:33Z