topic Data base read auto in QlikView

Data base read auto

Wed, 13 Jun 2012 11:19:48 GMT

hi all

i make a chart using OLE DB and each time i am open the chart its not bring data from database automaticlly it want to enter DB password

any method or way can make it auto ??? refresh the data and bring it from DB

Re: Data base read auto

Miguel_Angel_Baeyens — Wed, 13 Jun 2012 11:50:46 GMT

Hi,

The process you call "refresh data" is called "reloading" in QlikView. What reloading does is to execute all the lines in the script (Ctrl + E). In a Server environment, you can schedule those reloads to take place regarding some triggers (i. e.: each 10 minutes).

However, using Desktop you have either to use Windows Scheduler or manually click on the Reload button or Ctrl + R. Another option, though, is to create a trigger so when the document is opened using Desktop, it is reloaded. If you want to do this go to the Settings menu, Document Properties, Triggers tab, OnOpen, Add Action, Type External, Reload.

Note that each time you reload manually (using Desktop) you need to save the document, otherwise the next time you open the file you will see the same data, not reloaded data. Note that if several users are opening the same QVW this may cause deadlocks when saving the file.

Hope that helps.

Miguel

Re: Data base read auto

Wed, 13 Jun 2012 12:16:33 GMT

thanks for quick reply

please see the picture

Re: Data base read auto

Miguel_Angel_Baeyens — Wed, 13 Jun 2012 13:00:49 GMT

Ok,

I was assuming you were using version 11 of QlikView. Anyway, you can build a simple macro that will work when used in Desktop:

Sub MacroReload

ActiveDocument.Reload

End Sub

And use the same External type, but Run Macro.

Hope that helps.

Miguel