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: 
Not applicable

Filter Fix in Each Sheet

I'm not sure whether is it possible or not so I'm asking to all of you...Can I set my filter fix for each page? That is, I have 3 sheets: Green, Streets, Float and according to the filter data changes (obviously), but then I would like that in the Green page, I highlight Green (and see Green) BUT AT THE SAME TIME in the Streets sheet I can highlight Street and see their data...is it possible?

1 Solution

Accepted Solutions
sudeepkm
Specialist III
Specialist III

if you want to have the field value selected and locked then you need to set the action like below.

T116518.png

View solution in original post

9 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

maybe you can add actions on the onopen trigger of each sheet to select the value.

On the sheet properties-triggers-onopen add actions and select in Field your sheet-value

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

You could set the filter using an action triggered by OnActivateSheet on each sheet.

Or you could set an alternate state on each sheet, manually make the selections and then use the menu option Selection | Set Clear state to make those selections the default.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
its_anandrjs

Use field event triggers in the sheets.

Not applicable
Author

Thank you all, I was think about the trigger for each sheet, but I don't know how to use it...what should I write in "FIELD" and in "SEARCHING VALUE"? As you can see my only selection is from the table "Struttura" and in the picture is VERDE ORNAMENTALE...

sudeepkm
Specialist III
Specialist III

if you want to have the field value selected and locked then you need to set the action like below.

T116518.png

Not applicable
Author

Sudeep Mahapatra thank you!!!! That's what I was looking for!!! I must do that for each sheet right? So that each page is Blocked with the correct selection...

sudeepkm
Specialist III
Specialist III

if you have the same value (for example 'VERDE ORNAMENTALE') of the field Struttura to be selected in every sheet then keeping it on the first sheet or keeping it when the document opens should work.

T116518_1.png

In case your requirement is to change the value when you go to other sheets then on each sheet you need to apply the action by putting the Field's new value under Search String.

Not applicable
Author

I have a different value for each sheet, I must change the String Value....but when I open the document, will every selection remain fix? I have always add the "Block Field" action...

Not applicable
Author

yes it remains!

thank you once more Sudeep Mahapatra