Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 |
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.
@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