Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

chart data refresh

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

1 Reply

Re: chart data refresh

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