Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have too reload my qlikview application through publisher monthly.For example: Reload application every month Tuesday after 3rd Saturday.Is this possible to schedule to reload based on the above condition.
I am aware that we can do on every weekday there is option on trigger to run monthly on every 3rd Saturday.But not for 1st Tuesday after 3rd Saturday.
For example:
For month of April Qlik data load process should happen on night of 17th (3rd Tuesday) while in May it will be on night of 22nd (i.e. 4th Tuesday)
Can anyone helps me on this?
Regards,
Mayank
Hi Mayank,
I donot know if that is possible with QV Server Console but you could do the following:
How you you if the day is tuesday after the 3rd saturday of the month? Using this formula:
LET vsThisIsTheDay =Num(Day(Today())) = Num(Pick(Num(Weekday(MakeDate(Year(Today()), Month(Today())))) + 1, 23, 22, 21, 20, 19, 18, 24));
Hope this helps you!
Regards,
H
Hi Hector,
Thanks for your reply.
Can you please explain the below logic?How it is checking 1st Tuesday after 3rd Saturday
LET vsThisIsTheDay =Num(Day(Today())) = Num(Pick(Num(Weekday(MakeDate(Year(Today()), Month(Today())))) + 1, 23, 22, 21, 20, 19, 18, 24))
Regards,
Mayank
Hi Mayak,
What I do in the expession is compare current day (Num(Day(Today()))) with the first tuesday after the third saturday (rest of the expression).
Steps for the second part of the expression:
You can test that:
Regards,
H