Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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?

Tags (2)
1 Solution

Accepted Solutions
sudeepkm
Valued Contributor III

Re: Filter Fix in Each Sheet

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

T116518.png

9 Replies
Highlighted
bbi_mba_76
Valued Contributor

Re: Filter Fix in Each Sheet

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

MVP
MVP

Re: Filter Fix in Each Sheet

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

Re: Filter Fix in Each Sheet

Use field event triggers in the sheets.

Not applicable

Re: Filter Fix in Each Sheet

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
Valued Contributor III

Re: Filter Fix in Each Sheet

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

T116518.png

Not applicable

Re: Filter Fix in Each Sheet

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
Valued Contributor III

Re: Filter Fix in Each Sheet

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

Re: Filter Fix in Each Sheet

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

Re: Filter Fix in Each Sheet

yes it remains!

thank you once more Sudeep Mahapatra