Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor III

refrech

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

2 Replies
Highlighted
MVP
MVP

Re: refrech

Maybe like this in your script:

IF Hour(Now(1)) < 6 THEN

     //Connection string to PROD

ELSE

     //Connection string to COPY

ENDIF

Highlighted
Honored Contributor

Re: refrech

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

HirisH
“Aspire to Inspire before we Expire!”