topic Sheet Activation in QlikView

Sheet Activation

brindlogcool — Tue, 22 Nov 2011 20:08:09 GMT

Hi,

When i select a value in the check box then it should show the new sheet (Make it visible from hidden) and navigate to the activated sheet specific sheet of the selected value.If the list box has Customer,Product and when user selects customer it should enable the sheet customer and navigate to the customer sheet. I am able to make the sheet visible through the trigger. But i am not able to achieve both the actions at the same time using actions. Any suggestions

Sheet Activation

Wed, 23 Nov 2011 05:29:37 GMT

Create an Inline table with SHEETNAME and SHEETID (Product,SH01 etc..). Use the sheetname as a listbox with checkbox properties and enable select only one value.

Create a variable vActiveSheetID as Only(SHEETID). In each of the sheet properties set the visible condition as

vActiveSheetID = <sheetid>.

Go to document prooperties triggers, on field triggers, when selected and the following actions:

ActivateSheet and give sheet ID = vActiveSheetID.

Regards,

Kiran.