Exclusion of Public holiday and weekend and create T, T+1,T+2 dates accordingly

[shrijeeb]

Hello all,

I have below dates in calendar:

mon	27-Apr
tues	28-Apr
wed	29-Apr
thurs	30-Apr
fri	1-May	Public Holiday
sat	2-May	Saturday
sun	3-May	Sunday
mon	4-May
tues	5-May
wed	6-May
thurs	7-May
fri	8-May
sat	9-May	Public Holiday
sun	10-May	Saturday
mon	11-May	Sunday
tues	12-May
wed	13-May
thurs	14-May
fri	15-May
sat	16-May
sun	17-May

Need to create below format calendar table  on the available working days(excluding Weekends and Public Holiday)with T start, T end , T+1 start, T+1 end, T+2 start and T+2 end date. Where 

	available dates	T start	T end		T+1 start	T+1 end		T+2 start	T+2 end
mon	27-Apr	25-Apr	27-Apr		24-Apr	24-Apr		23-Apr	23-Apr
tues	28-Apr	28-Apr	28-Apr		27-Apr	27-Apr		26-Apr	26-Apr
wed	29-Apr	29-Apr	29-Apr		28-Apr	28-Apr		27-Apr	27-Apr
thurs	30-Apr	30-Apr	30-Apr		29-Apr	29-Apr		28-Apr	28-Apr
mon	4-May	1-May	4-May		30-Apr	30-Apr		29-Apr	29-Apr
tues	5-May	5-May	5-May		1-May	4-May		30-Apr	30-Apr
wed	6-May	6-May	6-May		5-May	5-May		1-May	4-May
thurs	7-May	7-May	7-May		6-May	6-May		5-May	5-May
fri	8-May	8-May	8-May		7-May	7-May		6-May	6-May
tues	12-May	9-May	12-May		8-May	8-May		7-May	7-May
wed	13-May	13-May	13-May		9-May	11-May		8-May	8-May
thurs	14-May	14-May	14-May		12-May	12-May		9-May	11-May
fri	15-May	15-May	15-May		13-May	13-May		12-May	12-May
mon	18-May	16-May	18-May		14-May	14-May		13-May	13-May

Need  help to create dates for T start, T end , T+1 start, T+1 end, T+2 start and T+2 end date in the above range format.

Thanks 

[Taoufiq_Zarra]

can you elaborate

how you calculated for example these lines ?

ues

5-May

5-May

5-May

1-May

4-May

30-Apr

30-Apr

tues

12-May

9-May

12-May

8-May

8-May

7-May

7-May

[shrijeeb]

Whenever there is a public holiday previous to working days, we club them together for creating dates range like:

4th May(Mon) we have 1st May(Fri) as a holiday so our 

T start date -1st May, Tend date- 4th May

for 5th May(Tues) we have 

T start date -5th May, Tend date- 5th May

T+1 start date - 1st May, T+1 end date -4th May (Its the date range of previous working days T start date and T end date).

Hope it is clear.

[Brett_Bleess]

@Taoufiq_Zarra  Just making sure you got notification, as I am guessing you did not on the new post given the issues we have been having.  Only thing of which I can think that may help is the Design Blog area, there are some posts on calendars and stuff out there, but I do not know if anything as specific as what you are trying to do, here is the main link you can use to search there:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Search on 'calendar' for starters, thinking the 4-4-5 one might be along the lines you are trying to do here, but I am not sure.  

Regards,
Brett