topic Re: Add trigger OnClickSheet to a Sheet in QlikView

Add trigger OnClickSheet to a Sheet

rudywelvaert — Mon, 07 Aug 2017 13:59:47 GMT

Hello,

Is it possible to add an extra trigger to a Sheet?

There are two standard trggers: OnActivateSheet and OnLeaveSheet.

Is it possible to add a trigger OnClickSheet to a Sheet?

Thanks

R.W.

Re: Add trigger OnClickSheet to a Sheet

passionate — Mon, 07 Aug 2017 14:01:43 GMT

What do you mean by OnClickSheet?

Re: Add trigger OnClickSheet to a Sheet

sunny_talwar — Mon, 07 Aug 2017 14:01:52 GMT

What is this trigger suppose to do?

Re: Add trigger OnClickSheet to a Sheet

suryaa30 — Mon, 07 Aug 2017 14:03:45 GMT

You can either based it on field selection or change in variable state with a click of a button. Please elaborate on your requirement

Re: Add trigger OnClickSheet to a Sheet

Miguel_Angel_Baeyens — Mon, 07 Aug 2017 14:04:38 GMT

OnActivateSheet is triggered every time you click on the tabrow on the tab for that sheet or another trigger activates (makes it visible) that sheet (e.g.: a text object with an icon that you use as a browsing aid).

If you mean when you click on the empty background then no, there is no such trigger, but you could create a text object for the background and add the trigger there.

Re: Add trigger OnClickSheet to a Sheet

passionate — Mon, 07 Aug 2017 14:06:34 GMT

Hi Rudy,

If OnClickSheet refer to area in sheet where there are no objects

then, Add a text box there with 100% Transparency and add trigger to text box.

Regards,

Pankaj

Re: Add trigger OnClickSheet to a Sheet

Anil_Babu_Samineni — Mon, 07 Aug 2017 14:07:58 GMT

Is it possible to add a trigger OnClickSheet to a Sheet?

Does it mean related the Navigation from One sheet to Next sheet. If so, This is possible

Re: Add trigger OnClickSheet to a Sheet

rudywelvaert — Tue, 08 Aug 2017 07:16:14 GMT

It's an event that standard does't exists on the Sheet objects

I like to add this event. It is triggered when I click a sheet

Thus not a Sheet object on the sheet, but the sheet itself

R.W.

Re: Add trigger OnClickSheet to a Sheet

rudywelvaert — Tue, 08 Aug 2017 07:17:49 GMT

It doesn't do anything, only it is triggered when the Sheet is clicked, not a sheet object on the sheet, but the sheet itself.

Re: Add trigger OnClickSheet to a Sheet

Miguel_Angel_Baeyens — Tue, 08 Aug 2017 07:18:01 GMT

That's what the OnActivateSheet does

Re: Add trigger OnClickSheet to a Sheet

rudywelvaert — Tue, 08 Aug 2017 07:21:00 GMT

I just need an event for the Sheets.

Now there exist only this two events:OnActivateSheet and OnLeaveSheet.

I want a third one: OnClick or OnClickSheet, what ever, that is triggered when the Sheet ( and not a sheet object) is clicked.

R.W.

Re: Add trigger OnClickSheet to a Sheet

rudywelvaert — Tue, 08 Aug 2017 07:23:35 GMT

Miguel,

Thanks. Are you sure such a trigger can't be added one way or the other?

R.W.

Re: Add trigger OnClickSheet to a Sheet

rudywelvaert — Tue, 08 Aug 2017 07:26:05 GMT

Anil,

Thanks

No I don't mean that.

I want an new, non-existing event added to the two that already exist, namely OnActivateSheet and OnLeaveSheet.

I want an event OnClick or OnClickSheet, what ever, that is triggered when the Sheet ( and not a sheet object) is clicked.

Re: Add trigger OnClickSheet to a Sheet

Anil_Babu_Samineni — Tue, 08 Aug 2017 07:49:44 GMT

That's where Miguel already replied. OnActivateShett can deserve this

Re: Add trigger OnClickSheet to a Sheet

rudywelvaert — Tue, 08 Aug 2017 08:04:58 GMT

Thanks

Re: Add trigger OnClickSheet to a Sheet

Miguel_Angel_Baeyens — Tue, 08 Aug 2017 08:17:49 GMT

I think it's a question of spelling rather than functionality. In QlikView, objects are not only "clicked" but "activated". When you click on a chart, you make it active. When you have an active chart, you can click on specific values, or a range of values (i.e.: drag and hold on a slider or a bar chart, or click on a specific cell in a straight table or pivot table charts).

Same happens with Sheets. Tabs are only a navigation aid, that you can even choose whether or not to display. Clicking on a tab activates a sheet. The sheet remains active until you activate a different sheet, which can be done using the tabrow clicking on a different tab, or by any other means like a button or a text object with a Layout action, when a field is selected or changed or when a variable gets a specific value.

If you see the API reference and some functions, they refer to "Activate" as both the action and the state of a sheet or object.

Re: Add trigger OnClickSheet to a Sheet

MattG — Thu, 21 Feb 2019 23:28:14 GMT

He's not asking for OnActivateSheet.
What he wants is an action triggered when you click on the background of an already active sheet.
Yes you could achieve the same thing with a transparent text box, but that becomes problematic when trying to add new sheet objects.

A possible use of such a trigger would be to hide/show objects