topic Sheet Trigger in QlikView

Sheet Trigger

Tue, 07 Jan 2014 12:57:58 GMT

Hi,

I have a report with 4 sheet.

1)Home

2)ETL

3)Summary

4)Detail

In my home page sheet, i have added 3 text objects for the Sheets ETL,Summary and Detail to get triggered.

In ETL text object, i added action as

Set Variable=vETL

Activatesheet=ETL but it's not working.am i missing out something here?

Thanks.

Re: Sheet Trigger

MK_QSL — Tue, 07 Jan 2014 13:04:52 GMT

What is your objective?

Do you want to click on text object for respective sheet to be appeared?

if it is then go to properties of respective text object

Go to Actions

Layout

Active Sheet

Write down Sheet ID ...

Sheet ID you can get from

Right Click Empty Space of any sheet

Properties

General

Sheet ID

Re: Sheet Trigger

trappersw — Tue, 07 Jan 2014 13:54:40 GMT

You only need one of the actions, not both, but you need to configure them.

Go to your sheet ETL and add in the properties of the sheet (tab General) the following:

ShowSheet

Conditional=Variable='vETL'

You can remove the trigger 'Activate Sheet ETL'

Instead of Activate Sheet: ETL you use the sheetID of this sheet (for example: SH03). You can find this ID in the top right corner of the properties menus of the ETL sheet (tab General).

Now you can remove the former trigger.

Hope this helps!

Re: Sheet Trigger

Tue, 07 Jan 2014 14:03:07 GMT

Hi.

I made a blunder...:P

Rectified that one.

Thanks for the quick reply.