Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

clear some fields while navigating from one sheet to another

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

1 Solution

Accepted Solutions
jrepucci15
Creator
Creator

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

View solution in original post

3 Replies
jrepucci15
Creator
Creator

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

Anonymous
Not applicable
Author

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"

jrepucci15
Creator
Creator

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)