topic How to create Activate Sheet trigger based on field value selection in QlikView

How to create Activate Sheet trigger based on field value selection

Fri, 30 Jan 2015 11:02:48 GMT

Hi,

How to set the active sheet trigger based on field value selection,

for example I have a field which has all the sheet names, so when I select any field Value that particular sheet should open, how can we do this, please suggest......

Re: How to create Activate Sheet trigger based on field value selection

jerrysvensson — Fri, 30 Jan 2015 11:06:36 GMT

There is an action called Activate sheet. You have to add Sheet ID as inparam.

Use a variable that contains current selection of your field value as Sheet ID?

Re: How to create Activate Sheet trigger based on field value selection

rubenmarin — Fri, 30 Jan 2015 11:07:45 GMT

Hi savi, an idea could be to set each SheetID with the name of the field value, so you can set a trigger on selections of that field, with an action Design-->Activate sheet, and the sheet id value: =SheetsField

Re: How to create Activate Sheet trigger based on field value selection

kiranmanoharrode — Fri, 30 Jan 2015 11:09:02 GMT

Create Inline Table

SheetList:

Load * Inline [

SheetID, SheetName

SH01, Home

SH02, Dashboard

SH03, Reports

];

Go to Settings -> Document Properties -> Triggers -> Select field (SheetName) from (Field Event Triggers) -> On select -> Add -> Layout -> Activate Sheet -> =Only(SheetID) in Sheet ID input box

On selection of SheetName trigger will activate corresponding Sheet

Regards,

Kiran