Reload only on weekdays

[guruprem]

Hi,

How can we make sure qvw loads only on weekdays. I am using Qlikview 12 and , I can see only option of loading Daily once but not to exclude on weekends. Please help?

[maxgro]

You an add an initial check in the .qvw for weekdays

For weekdays, raise an error, something like

let v3 = today(2);

IF not match(num(WeekDay($(v3))),5,6) THEN

  trace 'ok';

ELSE

  load '$(v3) not a weekday' from notexist.qvd (qvd);

ENDIF

[guruprem]

Your Idea is fantastic but, I can not believe that we have to handle this in script rather than on QMC. Are you sure that script is the only way to handle this?

[jonathandienst]

Select the weekly option. You should then be able to select the days within the week.

[sdmech81]

If u check I ur screen shot there is option of weekly as well.Then u pick the days inside week to refresh..Pretty direct igyess.

Sachin

[maxgro]

I think (I have to check) the weekly option with more than 1 days is for Publisher

Without publisher in weekly you can only choose 1 day

[sdmech81]

I think it should be there

Sachin

[sdmech81]

Plss check this out:

Attaching image..

Sachin

[kamielrajaram]

Hi,

You should be able to this from task scheduler

Kind Regards

Kamiel

[guruprem]

Hi ,

On 12.2 I do not see further option to select weekdays after choosing weekly in as per my screenshot. Kindly confirm if this is the same case with you.