topic Re: refrech in QlikView

refrech

master_student — Thu, 09 Mar 2017 07:56:19 GMT

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

Re: refrech

swuehl — Thu, 09 Mar 2017 08:49:28 GMT

Maybe like this in your script:

IF Hour(Now(1)) < 6 THEN

//Connection string to PROD

ELSE

//Connection string to COPY

ENDIF

Re: refrech

HirisH_V7 — Thu, 09 Mar 2017 09:20:10 GMT

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