Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Could you please provide me the steps as i am new to this?
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
I have followed the same steps while adding some column name with data but it is not working.
can any one give some idea on this ?
After adding new column in datasheet, it is not reflecting in existing report.
Can anybody suggest how to see newly added data in existing report?