Run a qvw on the 5th working day of the Month??

[bhupesh_gupta]

Hi All

I want to run a qvw file on the 5th working day of the month.

How can i achive this functionality.

Regards

Bhupesh

[datanibbler]

Hi Bhupesh,

just insert a condition like

>>> IF(day(date_field) <> 5, 'EXIT SCRIPT') <<<

=> Not sure this will work, haven't tried it yet, but the day() fct will return the day_of_the_month assuming you have a master_calendar with a date_field.

HTH

Best regards,

DataNibbler

[#3]

hi

maybe this image can help u

in qlikview management console i think you can achieve what you want

[bhupesh_gupta]

Hi Behnaz

What you have suggested will run the script on the 5th day of month while what I need is 5th working day.

Regards

Bhupesh

[bhupesh_gupta]

Hi Friedrich

Thanks for reply ....

I found the solution which is like this

I have created a qvw with the below mentioned code and schdule it from qmc .

Let varSystemAvailabl = NetworkDays( MonthStart (Today()), Today() );

if varSystemAvailable <> 5 then //5 as we need to run it on 5th working day
exit script;

ELSEIF

/// For Failure

Qlikview ; ///written to produce error

ENDIF;

And then we created the trigger on the failure of this task to run our desired application

Regards

Bhupesh