Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
thanks for quick reply
please see the picture
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