Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vijayit43
Creator
Creator

Schedule a task to run in particular dates every month and for every hour in QlikView

Dear All,

We want to create a Reloading Schedule task hourly on every month from 1st date to 10 date in Qlik view using Qlik view management console.


how to achieve this.

please suggest.  

 

Labels (1)
15 Replies
sunny_talwar

One option is to create 24 tasks one for each hour with Monthly setting which would allow you to pick all months and first 10 days.

image.png

vijayit43
Creator
Creator
Author

Hi Sunny,
but it's create more no of task. any other option to achieve this.
if yes please suggest.
sunny_talwar

I have not tried this and not sure if this will even work or not... but try to create a single hourly task and then within your script have an if statement which checks the day of the month

If Day(Today()) < 11 then

   YourScript

ELSE

Binary Load of your qvw

ENDIF;
pradosh_thakur
Master II
Master II

Hi Sunny

The else part might not work as binary load should be on first line of the script(correct me please if i am wrong)

We can instead add a partial reload so the data doesn't get lost. Again this is not tried and just an idea

If Day(Today()) < 11 then

   YourScript

ELSE

add load * inline [
dim
1
2
];

ENDIF;

We have to enable partial reload for that task in QMC. I would be keen to know if this works.

Learning never stops.
MindaugasBacius
Partner
Partner

The Windows Task Scheduler might be another option:

Screenshot_1.jpg

For an Action you need to create simple .cmd file like:

"C:\Program Files\QlikView\Distribution Service\QVDistributionService.exe" -r="c:\3.Load\File.qvw"

This works totally fine if you're familiar with Task Scheduler and .cmd files 🙂

sunny_talwar

You might be right, but why do you think Binary Load won't work? Just looking for obvious reasons that I don't know about.

pradosh_thakur
Master II
Master II

Qlik help says

"Only one binary statement is allowed in the script and it must be the first statement of the script, even before the SET statements usually located at the beginning of the script."

Because of this i thought binary load may not work. I am not sure how the above condition will behave inside the if statement. Again i would be happy to get corrected in case my understanding is wrong.

 

Learning never stops.
MindaugasBacius
Partner
Partner

Your suggestion is absolutely correct.
I looked from a different angle to this type of issue. There is no hidden secrets, just another type of solution.
sunny_talwar

Going to give it a shot and see what I find 🙂