topic Re: Filter Fix in Each Sheet in QlikView

Filter Fix in Each Sheet

Wed, 30 Apr 2014 09:34:34 GMT

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?

Re: Filter Fix in Each Sheet

bbi_mba_76 — Wed, 30 Apr 2014 09:42:08 GMT

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

Re: Filter Fix in Each Sheet

jonathandienst — Wed, 30 Apr 2014 09:47:17 GMT

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

Re: Filter Fix in Each Sheet

its_anandrjs — Wed, 30 Apr 2014 09:47:48 GMT

Use field event triggers in the sheets.

Re: Filter Fix in Each Sheet

Wed, 30 Apr 2014 10:20:25 GMT

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...

Re: Filter Fix in Each Sheet

sudeepkm — Wed, 30 Apr 2014 10:28:42 GMT

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

Re: Filter Fix in Each Sheet

Wed, 30 Apr 2014 10:35:07 GMT

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...

Re: Filter Fix in Each Sheet

sudeepkm — Wed, 30 Apr 2014 10:48:05 GMT

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.

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.

Re: Filter Fix in Each Sheet

Wed, 30 Apr 2014 11:02:10 GMT

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...

Re: Filter Fix in Each Sheet

Wed, 30 Apr 2014 11:06:10 GMT

yes it remains!

thank you once more Sudeep Mahapatra