sheet properties

[#1]

Hello,

In QV application, I noticed that

Sheet Properties>Triggers>OnActivate sheet(Edit Action) and OnLeave Sheet(Add Action).

How those would helpful in real time???

I need best example with this respect.

Pls help me out in this.

Rgs

Sattish

[Anonymous]

For example one may wish to set a selection on activating a sheet and clear it on leaving the sheet.

[Colin-Albert]

There is an explanation of QlikView triggers on this site

http://www.c-sharpcorner.com/UploadFile/35fef0/document-properties-triggers-in-qliview/

[jjordaan]

For example I have a very big appliation and I want that when a user goes to a certain always the data field current month is selected.

I do that with a on activate sheet trigger

[Colin-Albert]

Google "document properties Triggers in QlikView" and you will find a useful article describing triggers and the options available.

I have posted a link to the site, but it is held awaiting moderation.

[Anonymous]

Hi Satish,

OnActivateSheet
The action will be executed each time the sheet is activated.

OnLeaveSheet
The action will be executed each time the sheet is deactivated.

ex: when you want different selections made in sheet1 and sheet2,the selections of sheet1 are still persisting in sheet2,you use action 'clear all' for OnLeaveSheet trigger in sheet 1 and you can use  action 'Select in Field' for OnActivateSheet,to select desired values for a particular field  in sheet2.

you can learn more about Actions in Add Action dialog in Help file.

Regards

Neetha

[ecolomer]

see this example.

When you select a project, the last date are selected