Update data from database after every 30 sec.

[#1]

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 .

[Gysbert_Wassenaar]

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.

[#3]

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?

[Anonymous · Accepted solution]

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

[#5]

Hi Vaibhav,

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

[Anonymous]

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

[#7]

Hi Vaibhav,

thank you.i got.

[Anonymous]

hi snehal....

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

[#9]

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.

[Anonymous]

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.....