Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 4-5 sheets and they contain same filter pane across all the sheets. I want to set a value to be applied by default for all the sheets from one of the filter panes. Please help me to achieve this
This is how Qlik works by default - any filter applied anywhere will be applied everywhere.
yup but I do not want to do it by myself like you go and select a value from the filter pane, that particular selection should be there by default for e.g. within Countries I want that the dashboard should reflect values for 'Germany' all the time for all the tabs
If you want a specific object to always display the values for something - say Country = Germany - you should write that into the expression used in the object, for example:
Sum({< Country = {'Germany'} >} Sales)
For more details see Set Analysis in the documentation.
yeah, but then I need to do it for each and every visual repeating those for each and every tab. Is there any other way?
You would use this in the master measures and then re-use those measures across different objects.
You could also set all of these sheets to a different state and then apply a selection to that state and lock it in, but that's not an approach I'd recommend.
In Qlik Cloud you can apply filters to a visualization directly, but this is not available in Qlik Sense Enterprise so I've never used it myself. See:
Is it possible to lock a selection in filter pane? so, if the filter pane has three values suppose 2001, 2002, 2003, and 2003 is selected and locked, so now user cannot remove that selection from the filter pane but can select either 2001 or 2002. It will be really serving the purpose if it is possible.
I don't know if locks can be saved as part of a default bookmark, but you could give it a try. You could also mark this field as Always One Selected, and then apply a default using the default bookmark.