Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Filters across tabs

For f i wanted to use filters specfic to that tab in a document, how can i do that?

I have mutiple tabs and, say if i apply a filter on prodcut , i dont want that to be applied fro the other tab,

8 Replies
Highlighted
MVP
MVP

Re: Filters across tabs

try Alternate State

Highlighted
Partner
Partner

Re: Filters across tabs

You can use alternate state as suggested by tres, or you can set triger

on sheet properties--> trigers --> add action --> select in field --> choose the field you want to clear

and leave the search string empty (you can also put null())

Highlighted
Not applicable

Re: Filters across tabs

thanks for the reply. thsi works

but if i want to retain the filter after coming from the other tab, what should i do.

Highlighted
Partner
Partner

Re: Filters across tabs

You can set a bookmark that will be updated at every sheet leave as a trigger.

Then apply it back on sheet enter.

Highlighted
Partner
Partner

Re: Filters across tabs

But, I must say, I think the Alternate state will be more simple to implement.

Do you know how to use it? (only in QV11)

Highlighted
Not applicable

Re: Filters across tabs

No, I dont.

We are in QV11 only.

Highlighted

Re: Filters across tabs

Hi,

you can user the trigger. Go to sheet properies >triggers > OnActivesheet add clearAll action.

Highlighted
Partner
Partner

Re: Filters across tabs

Well, here is how you do it:

Document Properties --> General --> alternate states --> Add a state for each sheet

Now in each selection field on each tab go to properties and you will find alternate state in general tab. Sett all objects in the sheet to the sheet alternate group.

See attached example

If this is too much work then I suggest you use the other option I suggested.