topic Re: Reload only on weekdays in QlikView

Reload only on weekdays

guruprem — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Reload only on weekdays

maxgro — Wed, 15 Feb 2017 08:57:52 GMT

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

Re: Reload only on weekdays

guruprem — Wed, 15 Feb 2017 09:04:09 GMT

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?

Re: Reload only on weekdays

jonathandienst — Wed, 15 Feb 2017 09:06:53 GMT

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

Re: Reload only on weekdays

sdmech81 — Wed, 15 Feb 2017 09:15:51 GMT

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

Re: Reload only on weekdays

maxgro — Wed, 15 Feb 2017 09:22:13 GMT

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

Re: Reload only on weekdays

sdmech81 — Wed, 15 Feb 2017 09:39:03 GMT

I think it should be there

Sachin

Re: Reload only on weekdays

sdmech81 — Wed, 15 Feb 2017 09:48:08 GMT

Plss check this out:

Attaching image..

Sachin

Re: Reload only on weekdays

kamielrajaram — Wed, 15 Feb 2017 09:50:34 GMT

Hi,

You should be able to this from task scheduler

Kind Regards

Kamiel

Re: Reload only on weekdays

guruprem — Wed, 15 Feb 2017 16:46:20 GMT

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.

Re: Reload only on weekdays

sdmech81 — Wed, 15 Feb 2017 16:56:23 GMT

Whr is ur screenshot??

Sachin

Re: Reload only on weekdays

guruprem — Wed, 15 Feb 2017 17:04:31 GMT

Sorry missed screenshot, I will attach it tomorrow once I access my office machine but, the fact is there "is no option available to choose multiple weekdays even after selecting the "Weekly" reload

Re: Reload only on weekdays

sdmech81 — Wed, 15 Feb 2017 17:06:42 GMT

If it's really missing!!!!

Then we have to switch to windows Task scheduler to do that then..

Sachin..

Re: Reload only on weekdays

maxgro — Wed, 15 Feb 2017 18:34:28 GMT

With publisher

You can choose the days

Re: Reload only on weekdays

maxgro — Wed, 15 Feb 2017 18:35:07 GMT

Without publisher

Only 1 day in the week

Re: Reload only on weekdays

sdmech81 — Wed, 15 Feb 2017 18:50:37 GMT

Yes.. Wondering after Gurus comment abt it..How can they remove existing good feature!!