Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
try Alternate State
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())
thanks for the reply. thsi works
but if i want to retain the filter after coming from the other tab, what should i do.
You can set a bookmark that will be updated at every sheet leave as a trigger.
Then apply it back on sheet enter.
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)
No, I dont.
We are in QV11 only.
Hi,
you can user the trigger. Go to sheet properies >triggers > OnActivesheet add clearAll action.
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.