Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What you're describing seems to me like a bookmark, you should look into that.
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