topic Re: sheet properties in QlikView

sheet properties

Sat, 03 Jan 2015 12:07:31 GMT

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

Re: sheet properties

Anonymous — Sat, 03 Jan 2015 12:12:30 GMT

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

Re: sheet properties

Colin-Albert — Sat, 03 Jan 2015 13:33:01 GMT

There is an explanation of QlikView triggers on this site

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

Re: sheet properties

jjordaan — Sat, 03 Jan 2015 13:44:26 GMT

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

Re: sheet properties

Colin-Albert — Sat, 03 Jan 2015 14:27:34 GMT

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.

Re: sheet properties

Anonymous — Sat, 03 Jan 2015 19:59:35 GMT

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

Re: sheet properties

ecolomer — Sat, 03 Jan 2015 20:04:40 GMT

see this example.

When you select a project, the last date are selected