Does anybody know of a way to create an expression that has almost a filtering effect on all data in the tab?
For instance I have to build into every expression a set that looks at the user role field then filters based on this which is VERY cumbersome.
Is there any way to create an expression at the tab level that will create almost like a tab level "set analysis" (filter) based on this expression? I don't want something that actually filters (like on a list box).
I don't know of anything but I have to create an If statement on every expression on almost every tab based on a users role. Section access isn't possible for various reasons.
Hi you can try using bookmarks, triggers to do this.
1. save selections to bookmark
2. clear selection
Bookmark can save and retrieve the filter selections whenever we required, that's the great feature of BookMark in Qlikview.
An additional step for your requirements will be fulfilled by applying triggers only in "On-Leave" and "On-Activate" actions.i.e; Right-Click on sheet --> Properties --> Triggers --> Sheet Events
1.)On-Leave
Action Type --> Bookmarks --> ReplaceBookmark= BM01
Action Type --> Selections --> ClearAll
2.)On-Activate
Action Type --> Bookmarks --> ApplyBookmark = BM01
