topic Re: Update data from database after every 30 sec. in QlikView

Update data from database after every 30 sec.

Thu, 15 Nov 2012 09:10:18 GMT

Dear all,

i am fetching data from sql database in qlikview.now i need is the data should be update every 30 sec.

can any one help .

Re: Update data from database after every 30 sec.

Gysbert_Wassenaar — Thu, 15 Nov 2012 09:14:47 GMT

I think you'll want to read this discussion. You could also try to set the reload schedule on qlikview server for the document to 30 seconds.

Re: Update data from database after every 30 sec.

Fri, 16 Nov 2012 05:44:16 GMT

Dear Gysbert,

i am using qlikview personal edition.in that i am not getting where is QEMC(qlikview enterprise management console).so how to achive this withouth QEMC?

Re: Update data from database after every 30 sec.

Anonymous — Fri, 16 Nov 2012 07:04:15 GMT

hi snehal,

U can use Batch file to reload ur app and schdule it using ur windows scheduler.....

Hope tat can solve ur problem....

Regardz,

Vaibhav

Re: Update data from database after every 30 sec.

Fri, 16 Nov 2012 08:58:58 GMT

Hi Vaibhav,

Thanks for reply.how to do batch file to reload?please can you give detail.

Re: Update data from database after every 30 sec.

Anonymous — Fri, 16 Nov 2012 09:17:24 GMT

jst a simple

in a note pad - write following

"C:/Program Files/Qlik View/ Qv.exe' /r "Ur application path goes here "

Save the above note pad wit .bat extension

tatz it

Re: Update data from database after every 30 sec.

Fri, 16 Nov 2012 10:04:11 GMT

Hi Vaibhav,

thank you.i got.

Re: Update data from database after every 30 sec.

Anonymous — Fri, 16 Nov 2012 10:10:43 GMT

hi snehal....

.plz close thiz discussion by marking helpful or correct answer accordingly.....

Re: Update data from database after every 30 sec.

Fri, 16 Nov 2012 10:28:02 GMT

Hi Vaibhav

i wrote "F:/Qlik View/Qv.exe" /r "F:/new reports/test.qvw" in notepad.and i scheduler it. but it not getting update.

Re: Update data from database after every 30 sec.

Anonymous — Fri, 16 Nov 2012 10:40:14 GMT

I shud..... chk d path ...... if itz proper.....or double click on the batch file u made....if by double clicking on batch file creates to relaod ur app den ur path is correct n scahedule it properly.....

Re: Update data from database after every 30 sec.

Fri, 16 Nov 2012 11:51:46 GMT

Hi Vaibhav

Thank you.now my data is updating.