Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
akushary
Contributor III
Contributor III

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

akushary
Contributor III
Contributor III
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)