https://community.qlik.com/t5/Suggest-an-Idea/Identifying-last-n-working-days-in-script-via-master-calendar/idi-p/1571167 <P>I was working to identify records with dates in last 5 working days (From max date in transactions).&nbsp; This logic could then simplify set-analysis and enable a faster end-user experience.&nbsp; Consider adding this in your calendar script:&nbsp; if(TempDate&gt;= Date(FirstWorkDate('$(vMaxDate)',5)), 1,0) as LastFiveWorkDays,</P> <P>&nbsp;</P> <P>Temp:<BR />Load<BR />min(startdate) as minDate,<BR />max(startdate) as maxDate<BR />Resident Transactions;<BR /><BR /><BR />Let varMinDate = Num(Peek('minDate', 0, 'Temp'));<BR />Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));</P> <P>DROP Table Temp;<BR /><BR />TempCalendar:<BR />LOAD distinct<BR />$(varMinDate) + Iterno()-1 As Num,<BR />Date($(varMinDate) + IterNo() - 1) as TempDate<BR />AutoGenerate 1 While '$(varMinDate)' + IterNo() -1 &lt;= '$(varMaxDate)';</P> <P><BR />MasterCalendar:<BR />Load<BR />TempDate as startdate,<BR />if(TempDate&gt;= Date(FirstWorkDate('$(vMaxDate)',5)), 1,0) as LastFiveWorkDays,<BR />Date('$(vMaxDate)') as MaxDate<BR />Resident TempCalendar<BR />Order By TempDate ASC;<BR />Drop Table TempCalendar;</P> Wed, 25 Nov 2020 15:12:24 GMT sandeep_sarawgi 2020-11-25T15:12:24Z https://community.qlik.com/t5/Suggest-an-Idea/Identifying-last-n-working-days-in-script-via-master-calendar/idc-p/1642984#M908 Archiving - This is a discussion, not an idea. Tue, 05 Nov 2019 10:12:14 GMT https://community.qlik.com/t5/Suggest-an-Idea/Identifying-last-n-working-days-in-script-via-master-calendar/idc-p/1642984#M908 John_Teichman 2019-11-05T10:12:14Z https://community.qlik.com/t5/Suggest-an-Idea/Identifying-last-n-working-days-in-script-via-master-calendar/idc-p/1642985#M909 Tue, 05 Nov 2019 10:12:25 GMT https://community.qlik.com/t5/Suggest-an-Idea/Identifying-last-n-working-days-in-script-via-master-calendar/idc-p/1642985#M909 John_Teichman 2019-11-05T10:12:25Z