refrech

[master_student]

Hello Guys,

I hope everything is okay

I have a report that connnects to a PROD database to refrech at 5 in the morning because the user that I use is locked during the day. but i can access to the database clone (copy of the prod) that is accessible all the day. I need to refrech the report 3 times ; the first at 5 am it connects to the prod to get the data and the two other times at 12h and 16h it connects to the clone database

so in my script i need to make this change

if refrech time =5 => connexion to the prod else connection to the clone

any idea how to write this script?

Thanks

[swuehl]

Maybe like this in your script:

IF Hour(Now(1)) < 6 THEN

     //Connection string to PROD

ELSE

     //Connection string to COPY

ENDIF

[HirisH_V7]

Hi,

Check out this,May be the other way than from script.

Auto Reload in script | Qlik Community

Batch file script to reload Qlikview Applications

HTH,

HirisH