Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
caccio88
New Contributor III

Configuring an automatic reload twice a month with the QlikView Management Console?

Hi guys,

what I would like to do is to set that my app will be reloaded on the 1st day of the month and on the 15th of the same month.

On the management console I don't have this chance, but only every day, week, month...

So I thought to set the reload every day and change something in my script that doesn't really reload the app if is not the 1st day of the month and on the 15th of the same month, but I simply don't know how...

Any idea?

Thank u all.

Filiberto

stalwar1swuehlgwassenaar

1 Solution

Accepted Solutions
Employee
Employee

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Configure to reload daily

Use this script

IF Day(Today()) = 1 or  Day(Today()) = 15 then

  // Put your script here

ENDIF

24 Replies
sasikanth
Valued Contributor III

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

HI,

Please check the option daily and make it as

For every 15 days and start time .

Please check it once

Thanks

Sasi

MVP
MVP

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

You can also use the EDX trigger mechanism

Using EDX in QlikView 11

and use a command line script triggered by Windows task scheduler to fire the EDX trigger.

The Windows task scheduler can be set up to fire on 1./ 15. each month.

Employee
Employee

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Configure to reload daily

Use this script

IF Day(Today()) = 1 or  Day(Today()) = 15 then

  // Put your script here

ENDIF

manucamon
Valued Contributor III

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Hi Filiberto.

Don't have this options?

Employee
Employee

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

This screen only shows if you´re using a Publisher (not sure if it´s the case)

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Manuel's screen shows the Trigger options if you have a publisher licence.

If you just have server and no publisher then you can only have one trigger per reload task and do not have this flexibility.

cleveranjos‌ has suggested a workaround.

Set the task to load daily at the time you require, and then add his IF statement around the whole of your load script, so the load only occurs on days 1 and 15.

caccio88
New Contributor III

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

I think that could work for me.

Thank you so much cleveranjos

MVP
MVP

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Just take care that you don't end up with an empty data model in your dashboard on all other days

manucamon
Valued Contributor III

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Hi Colin,

Filiberto don't specify if he has Publisher or not, and I am answering if he has this option or not.

I know that this option is only for Publisher.

Thanks.

Community Browser