How to make the dashboard run on 12th working day of every month.

[syedmazhar]

I have a dashboard which we need to schedule to run on every months 12th and 15th working day of every month. 

Initially i had scheduled to run on 12th and 15th of every month but this is not correct. 

12th and 15th business working day can fall on any other day as well.. Is their a way to handle this issues.

Thanks in advance.

Syed 

[tresesco · Accepted solution]

Try like:

Let vMy12thWorkingDate =LastWorkDate(MonthStart(today()), 12);

Then you can use an IF condition to check if today is equal to this date or not..

[Brett_Bleess]

Syedmazhar, did Amit's suggestion work for you?  In the If statement, the not equal would be a Exit Script call:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

If you got things working, do not forget to return to the thread and use the Accept as Solution button on Amit's post to give him credit for the assistance and let others know this worked.  If you are still working on things, leave an update on what you need.

Regards,
Brett