Clear fields for some tabs, keep some fields for other tabs

Anonymous — Tue, 16 Sep 2014 09:08:04 GMT

Situation:

Multiple sheets having certain relation to each other. To illustrate: sheet 1,2,3 are related, sheet 4 is unrelated, sheet 5 and 6 are related with each other and to top it off, sheet 7 is partially related to 1,2,3.

Goal:

When moving to another related tab fields should stay selected. When moving to an unrelated tab fields should be cleared. When moving to a partially related tab 5 fields (of the 100+) should be kept selected. I saw this thread:

Clear all Selections except few fields

Where the solution (from Michiel van de Goor) is:

On active sheet I set 3 triggers:

Select in field <Year> with the expression: =GetFieldSelections(Year)

Select in field ....

for each dimension I want to keep selected.

Which could be a solution for the partial related sheet. Is there way of scripting the clear all fields function depending from which tab it arrived?

topic Clear fields for some tabs, keep some fields for other tabs in QlikView

Clear fields for some tabs, keep some fields for other tabs