topic Re: Field Event Trigger vs Sheet Event Trigger in QlikView

Field Event Trigger vs Sheet Event Trigger

Wed, 26 Nov 2014 07:44:07 GMT

I have a Field on a particular sheet (this sheet has its own group of actions - lets call it Sheet1),

On this Field I've placed a Field Event Trigger to activate another sheet.

On the sheet that is activated i have an OnActivateSheet Trigger which has its own group of Actions (let call this Sheet2).

But it seems like the Actions set out in Sheet1 are carried over to Sheet2 when activated and ignores the actions on Sheet2.

Is there anyway for the actions/selections in Sheet1 to be cleared when Sheet2 is activated?

Ive tried ClearAll and ClearField on Sheet2 as well as ClearAll OnLeaveSheet for Sheet1 - but it doesnt seem to solve my problem.

Any help would be appreciated.

Regards,

Magen

Re: Field Event Trigger vs Sheet Event Trigger

ashfaq_haseeb — Wed, 26 Nov 2014 07:50:33 GMT

Hi,

Why not place sheet 2 in another alternate state.

Hope it helps.

Regards

ASHFAQ

Re: Field Event Trigger vs Sheet Event Trigger

Wed, 26 Nov 2014 08:12:08 GMT

Hi Ashraf

Can you give me an example please - im tying it but it doesnt work entirely.

If i place it in an alternate state it clears everything.

How do i create a state inclusive of sheet actions.

Regards,

Magen

Re: Field Event Trigger vs Sheet Event Trigger

ashfaq_haseeb — Wed, 26 Nov 2014 08:13:54 GMT

Hi,

Can you attach a sample app?

Regards

ASHFAQ

Re: Re: Field Event Trigger vs Sheet Event Trigger

tresB — Wed, 26 Nov 2014 08:20:35 GMT

In the field event trigger itself add one more trigger to 'Clear All' or so. See attached sample.

Re: Re: Field Event Trigger vs Sheet Event Trigger

Wed, 26 Nov 2014 08:32:07 GMT

Hi Tresco

That helps but it still clears everything when landing on the activated sheet.

It doesnt select the actions laid out in the activated sheet.

Regards,

Magen

Re: Re: Field Event Trigger vs Sheet Event Trigger

ashfaq_haseeb — Wed, 26 Nov 2014 08:37:41 GMT

Hi,

I checked with field even trigger landing to sheet2. On open trigger is not working.

You may need to contact support for the same.

Regards

ASHFAQ