Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
stevelord
Specialist
Specialist

QV Management Console, reload document hourly M-F, 7am-7pm?

Hi I can't seem to find a combination of options to set a document to reload hourly only M-F from 7am to 7pm.  There are some documents we only want to run during business hours, then to stop while other more humongous documents or scans do their things overnight and on weekends.  (Pretty impressive what happens when a little minute-reload dashboard trips into certain other processes once or twice a week. )

1 Reply
vikasmahajan

Hello

This is type of functionally we will be achieve by running qvw using batch file external dos prog and run this through macros , on post realod of document.

Also schedule in windows scheduler . Find command to run qvw for batch and how to schedule jobs in windows

Batch File

-----------------------------------------------------------------

TITLE RELOAD - EXPORT - MAIL BATCH

ECHO OFF

CLS

ECHO The Dashboard is reloading.

ECHO This may take several minutes to execute and may appear

ECHO to be unresponsive. This is normal.

ECHO Please be patient and do not exit.

"C:\Program Files\QlikView\QV.exe" /VvTriggerMacro=0 "C:\Export-Email-Automation\Dashboard.qvw"

EXIT

Enjoy

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.