topic Tab level filtering automated in QlikView

Tab level filtering automated

zagzebski — Thu, 17 Jul 2014 02:41:59 GMT

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.

Thanks in advance for any advice...

Re: Tab level filtering automated

Siva_Sankar — Thu, 17 Jul 2014 03:00:22 GMT

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

Or try the link below

filtering data for a whole sheet

Regards,

Siva