Dynamic reloading of data into qlikview

[#1]

Hi,

How do we dynamically load the data in qlikview.

I mean if i open the report it should be refreshed with the current data without the user doing the reload operation.

Please help.

Its urgent.

Thanks in advance.

[#2]

If you use Qlikview server, then schedule reloads / partial reload along the day.

If you use Qlikview analyzer you need to create batch to reload them

Now if you want to reload applications using a macro in a web page , you need to use EDX, but I never done that in a document macro...

How do you plan to access your documents ?

Rgds,

Sébastien

[biester]

The plan as I understand it is:

When opening a QlikView-document or application (qvw) it should automatically be reloaded.

I know only of one way to achieve the desired: open it locally (not in server) and by an OnOpen - trigger reload it.

Rgds,
Joachim

[prieper]

Think that one has to live with the fact, that the QV-data are always static at a certain point of time. You only may shorten the intervals, when an application is refreshed. If real online-data is required, think that QV is not the appropriate tool - then it will be direct ODBC and SQL as your favourite language.

Peter

[#5]

Hi Joachim,

You can put a button on the sheet or whenever a sheet opens/activates(or however you want to fire the action), and add a little macro with > ActiveDocument.Reload.

Thanks

[biester]

Xena,

yes, you can, but the reload should take place (as I understand it) on opening a document and not on activating a sheet.

Using a button would not be an automatic reload. Besides, I'd not use a button with a macro if a can use Ctrl-R.

Rgds,
Joachim

[#7]

You can add an Action on the OnOpen 'Document Event trigger'

[biester]

Correct; that's what I suggested in my first post to this thread.

[#9]

Thank you very much.