Data base read auto

[#1]

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

[Miguel_Angel_Baeyens]

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

[#3]

thanks for quick reply

please see the picture

[Miguel_Angel_Baeyens]

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