topic Filters across tabs in QlikView

Filters across tabs

Wed, 24 Jul 2013 03:13:35 GMT

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,

Re: Filters across tabs

tresB — Wed, 24 Jul 2013 04:37:40 GMT

try Alternate State

Re: Filters across tabs

orital81 — Wed, 24 Jul 2013 06:57:10 GMT

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())

Re: Filters across tabs

Wed, 24 Jul 2013 07:31:04 GMT

thanks for the reply. thsi works

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

Re: Filters across tabs

orital81 — Wed, 24 Jul 2013 07:36:14 GMT

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

Then apply it back on sheet enter.

Re: Filters across tabs

orital81 — Wed, 24 Jul 2013 07:37:39 GMT

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)

Re: Filters across tabs

Wed, 24 Jul 2013 08:36:27 GMT

No, I dont.

We are in QV11 only.

Re: Filters across tabs

Kushal_Chawda — Wed, 24 Jul 2013 08:45:53 GMT

Hi,

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

Re: Filters across tabs

orital81 — Wed, 24 Jul 2013 08:56:07 GMT

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.