topic Re: Clear all fields but some in QlikView

Clear all fields but some

anagharao — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Clear all fields but some

susovan — Thu, 30 Jun 2016 06:37:14 GMT

Hi Anagha,

You can try this way

Re: Clear all fields but some

anagharao — Thu, 30 Jun 2016 06:40:18 GMT

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.

Re: Clear all fields but some

kristof_j — Thu, 30 Jun 2016 06:46:44 GMT

Select 'Clear Other Fields'

Re: Clear all fields but some

kristof_j — Thu, 30 Jun 2016 06:53:03 GMT

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'

Re: Clear all fields but some

andrespa — Thu, 30 Jun 2016 07:09:11 GMT

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

Cheers,

Andrés