Skip to main content
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

You were right, the work around could be this

Binary test_binary1.qvw;

IF Day(Today()) < 11 THEN
	
	DROP Table; //Drop all tables from binary load qvw
	
	Table:
	LOAD * INLINE [
	    Dim
	    1
	    2
	];
	
ENDIF
vijayit43
Creator
Creator
Author

Hi Mindaugas Bacius,

I think it's work for me wen we are using windows scheduler. but we are 10 dashboard which are dependent from one to another dashboard Reload Schedule.
how to we achieve dependencies in windows scheduler if you suggest it's great help full for me.

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

In my practice we had the same issues. As I remember we just created one .cmd file like below:

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

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

This should run the File1. After the File1 is saved the other File2 start reloading.

Did it work?

vijayit43
Creator
Creator
Author

Can we do anything if first Reload schedule is success full then another is start other wise end script in batch file.

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Unfortunately, I am not sure how to make this. I suggest just google it.
Trail - error method the cmd until you achieve the desired result.
pradosh_thakur
Master II
Master II

did you try the suggested approach by  @sunny_talwar  and me ? If not please try and let us know if it works for you.

Learning never stops.