topic clear some fields while navigating from one sheet to another in QlikView

clear some fields while navigating from one sheet to another

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

Hi,

I have multiple sheets in a dashboard.

While users can select multiple fields in one sheet, i need to clear all except region, country,state (these 3 are grouped as one dimension called Geography).

Please can anyone suggest a script/macro to enable this functionality.

Thanks in advance

Re: clear some fields while navigating from one sheet to another

jrepucci15 — Wed, 01 Mar 2017 18:51:14 GMT

See Sheet properties / Triggers

My typical process is
Lock Field (in your case, region, etc...)

Clear All

Unlock All

Also see:

Select in Field

or Clear in Field

Re: clear some fields while navigating from one sheet to another

Anonymous — Thu, 02 Mar 2017 19:44:14 GMT

Yeah i know we can use the Clear Field as Action, but i was actually looking for some code if we can add do it together rather than adding each field with"Clear Field"

Re: clear some fields while navigating from one sheet to another

jrepucci15 — Thu, 02 Mar 2017 19:50:21 GMT

I agree, it would be nice to have some code rather than do the tedious process of setting up the triggers and actions.

Most of my pages have both on enter & on exit triggers AND actions attached to the "Clear" button.

I also have some Document Properties / Triggers (of all three varieties).

At least once a year I have to sweep through all of the applications and update the documentation showing all of the actions & triggers. Tedious. Would be nice if there was a central spot for all of those. (sigh)