Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Apply all filters together?

I am developing a report which consists on several filters. When I hit one filter, it triger the whole reports and App starts refreshing the data. I am looking for a way to first select all the filters and then hit a button to refresh the data. Is there a way in QV to allow user to select all the required selection and hit some button  such as "search" to see the final result based on these filters?

Thanks in advace.

TA

2 Replies
danielrozental
Master II
Master II

What you're describing seems to me like a bookmark, you should look into that.

Anonymous
Not applicable
Author

Hi,

When you say "when I hit one filter, it triger the whole reports and App starts refreshing the data" are you talking about how filters are linked to each other via the data model, and that by selecting one field other linked fields aree selected (e.g. select USA country and Chicago, New York etc Cities are selected) ? This is how QlikView works, hence the name, Click-View.

If you really want to override it, you could:

1. Add a search field to your Charts sheet with the fields and encourage your users to hold down the Ctrl key when making selections. Display would then only happen upon release of the Ctrl key

2. Put the filters on one sheet and then show users a charts sheet (that would have been updating with each selection all along) when they press a Run button.

3. Ccreate a parrallel set of unlinked fields (using tables that aren't linked to the data being summed up in charts etc., or to each other even), and then use some quite complex Macros code to read from these unlinked fields and apply the same field values to the linked fields when you press a Run button.

Jonathan