I have a sheet that need to be pre-filtered using multiple fields (5-6). Eg: one of the filters is year slicer which must be current year when user open sheet.
- If I use bookmark, the sheet loads fast but they removed users' other filters.
- If I use sheet action or button, filters are applied in sequence which is very slow although other filters manually selected by users still available.
Is there any solution that can make qlik execute all actions of a button/sheet at once instead of one by one?
As Action selections are known values, one possible technique is to generate a proxy field in the data model that is linked to the desired multiple field selections. Then the Action need only select the single proxy field.
The reason to have multiple filters is to allow users to change them afterward, so that they can check out other combinations too. The proxy field might be less flexible in that case (concatenating is one options but does not seem to be clean enough).
I think the problem here is the data loading in the app , changing the actions , applying the filters in Sequence might not be possible as per my knowledge . In order to make the sheet load faster , I would suggest put a condition to load the data/charts only when the filters are selected so this avoids the data being pre-loading of charts which takes time to load.
For my specific case, turn out the solution is extremely simple that it makes me laugh!
Create a custom dimension in Filter Panel, something like =if(Col1='N' AND Col2='Y' AND Col3='N' AND Col4 = 'M' AND NOT Col5='G', 'Default Filter', null())
When user choose default, all of the 5 cols would be available on top panel for users to interact AND they are all load at once, not by sequence
yes, as I mentioned in my original post, the only problem I have with bookmark is bookmark removes other filters (that's not in the 5 columns). If you can somehow make it inherited users' current filters, it would definitely be a solution.
