Clear all fields but some

[anagharao]

Hi everyone.

I have several pages referring to disjoint data sets each, thus filter added in one page affects the others adversely. Would it be possible to clear all field selections on leaving a page(through triggers) except Yr, Month and a few others?

Thanks,

Anagha

[susovan]

Hi Anagha,

You can try this way

[anagharao]

Hi Thank you for the reply.

However i would like to clear all fields excluding some fields. I dont want to specify clear field to over 50 dimensions so i wondering if there is a quicker way to do this.

[kristof_j]

Select 'Clear Other Fields'

[kristof_j · Accepted solution]

Or you can first lock several fields by adding 'Lock Field' for each field you want to keep.

And then 'Clear All'

And 'Unlock All'

[andrespa]

Didn't know this! It`s a good one.

Cheers,

Andrés