how to repeat dates till next given date in qlik view

[Abhishekb]

Hi Community,

I have a Quarter End Date. And I want to repeat that date till the next delayed days.

ONLY WORKDAYS SHOULD BE CONSIDERED FOR DELAY DAYS.

Can you help me for this.

Thanks in advance.

[Abhishekb · Accepted solution]

Hi @brokinsa23 ,

Thanks for your solution but I got much more optimized way for this problem.

let vToday = Today();
LET vQuarterEndDate = QuarterEnd('$(vToday)',-1);

Let vDelay1 = $(vDelay);
Let vDelayDate = Date(LastWorkDate('$(vQuarterEndDate)'+1,'$(vDelay1)'));

Load
if(('$(vToday)'= WeekDay('$(vToday)') or '$(vToday)' <> WeekDay('$(vToday)')) and '$(vToday)' <= '$(vDelayDate)',
QuarterEnd('$(vToday)',-1),
'$(vToday)'
) as EndResult

Resident MainTable;