how to repeat dates till next given date in QlikView

[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]

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 Community,

I got the answer.

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

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

MainTable:

Put your data here....

Output:

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

Resident MainTable;

This is the solution. Thank you