Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
michaelfentondata
Partner - Contributor III
Partner - Contributor III

Clear All on Reload or client Refresh

Is it possible to clear all filters when a document is reloaded or the client triggers a refresh in their browser?

We have an app that should always default to showing all data.  It is displayed on a team monitor and is refreshed every 15 minutes.  If someone accidentally applies a filter, It should be cleared the next time a reload/refresh occurs.

Labels (1)
3 Replies
selvakumarsr
Creator
Creator

You can right a trigger for it..

Action--> Selection---> Clear all or Clear Field or Clear other field..

In Document Properties--> Triggers--> Document Event trigger you can set the trigger..

or you can right macro and call the macro in the trigger...

Sub Clear()

ActiveDocument.SetClearState

ActiveDocument.Clear

End Sub

er_mohit
Master II
Master II

Not applicable

ClearAll-Reload.png

Clear All while Reload.

Settings ->  Document Properties -> Triggers -> OnOpen Click on Add Action(s)

                Actions -> Add -> Selection(Action Type) -> Clear All

Show the Default Sheet Tab when you open the Document.

Clear All while Reload.

Settings ->  Document Properties -> Triggers -> OnOpen Click on Add Action(s)

                Actions -> Add -> LayOut(Action Type) -> Activate Sheet , Next to Sheet ID Mention the required Sheet Name.

Hope you got the Answer