Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to create Activate Sheet trigger based on field value selection

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......

3 Replies
Partner
Partner

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

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

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

kiranmanoharrode
Contributor III

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

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