topic Re: Trigger on a sheet / chart in QlikView

Trigger on a sheet / chart

Tue, 23 Oct 2012 08:56:17 GMT

Hi,

I am attempting to add a filter to a sheet object (Pivot Chart) so that it default to showing only data from today.

I have added to the sheet event trigger (OnActivateSheet), Action Type = Selection, Action = Select in Field

The field is set to the Date field and the search string is set to getdate()

But this does not seem to work.

Can anyone tell me when the triggers get fired?

Also, have I done the trigger incorrectly?

Thanks.

Geoff

christophebrault — Tue, 23 Oct 2012 09:03:08 GMT

Hi,

It seems to be correct be sure that :

In the field, don't write "=" before your Date

In the search string, try : today() and be carefull you have the same date format.

Share a sample file if it's still not working.

Tue, 23 Oct 2012 09:10:45 GMT

screen attached

Tue, 23 Oct 2012 10:18:02 GMT

Thanks for the Cristina.

The trigger gets fired when the document is (re)loaded.

Can you get the trigger to fire when the tab is switched to?