topic Re: Sheet Properties in QlikView

Sheet Properties

mario-sarkis — Fri, 22 May 2015 15:10:46 GMT

hey all

My question is that i have many sheets tab in the same dashboard my request is

when i select a field on the first sheet i need to clear it's selection when i move to other sheets and VICE VERSA But when i select on a field in the other sheets it will remove its selection only when i move to the first sheet .

Hope that you can help .

Thank you,

Re: Sheet Properties

Fri, 22 May 2015 15:14:32 GMT

Hi Mario,

sounds like you just want to clear the selection when going to or leaving that first sheet? If so you can see a trigger on the specific sheet to do that on activate and leave.

Hope that helps

Joe

Re: Sheet Properties

Anonymous — Fri, 22 May 2015 15:14:35 GMT

You need to add action "clear all" to both "enter sheet" and "leave sheet" triggers - only on the first sheet.

Re: Sheet Properties

Anonymous — Fri, 22 May 2015 15:22:56 GMT

Apply sheet triggers in all sheets as on activate sheet: clear all Trigger

Re: Sheet Properties

Anonymous — Fri, 22 May 2015 15:39:54 GMT

Hi,

On each sheet select, Sheet Properties--->Triggers---> Sheet Event Triggers ---> On Active Sheet---> Edit Actions

Add Action--->Selection-->Clear All

this form every time you to open one sheet will clear selections previous

Regards!!

Jannet.