topic Re: How to reload report with new data? in QlikView

How to reload report with new data?

Thu, 01 Nov 2012 11:15:59 GMT

Can anyone give information how to reload report with newly changed data automatically in qlik view report?

If data changed then present report will refresh with new data.

Gysbert_Wassenaar — Thu, 01 Nov 2012 11:28:03 GMT

If you're using QV11 you can add a OnOpen trigger and add a Reload action. If you're using QV10 you can add an action to run a macro like below:

Sub ReloadOnOpen ActiveDocument.Reload End Sub

Thu, 01 Nov 2012 11:32:14 GMT

Could you please provide me the steps as i am new to this?

Gysbert_Wassenaar — Thu, 01 Nov 2012 11:43:05 GMT

Click on Settings in the menu and choose Document Properties.

Click on the Triggers tab.

Under Document Triggers select OnOpen.

Click on the Add Action(s) button.

Click on the Add button.

Select External under Action Type.

Next click on Run Macro.

Type ReloadOnOpen in the text box below Macro Name.

Next click on the Edit Module button.

Add the code below:

Sub ReloadOnOpen ActiveDocument.Reload End Sub

Click on OK to exit the module editor.

Click on OK to add the action and return to the properties screen

Click on Ok to exit the properties screen

Thu, 01 Nov 2012 12:21:55 GMT

I have followed the same steps while adding some column name with data but it is not working.