Default Sheet

[#1]

Hi All

I have added a new sheet to several qlikview documents.

I would like the models to now default to the newly created sheet upon opening. How do I configure this?

[alex_millan · Accepted solution]

Hi,

Go to:

Document properties --> Triggers --> Document event triggers --> On open --> Add --> Layout --> Activate Sheet (your desired sheet_id)

Regards.

[chrislofthouse]

Document settings-> Triggers -> OnOpen-> -> Add Action -> Layout -> Activate Sheet

[maleksafa]

go to settings, document properties, triggers, select 'onOpen' Document event triggers, add actions, select 'Layout' from  Action type, Activate Sheet and put the sheet id

[awhitfield]

Hi Tumelo,

you want to add an OnOpen trigger, via Document Settings > Triggers.

Action > Layout > Activate Sheet, specify the ID of the sheet that you wish to Open by default when the document is Opened.

Andy

[datanibbler]

Hi,

in the document_properties (Ctrl+Shift+D), go to tab "Actions" and configure a "on opening document" action to activate that sheet - you need to specify the sheet_ID that you get on the "General" tab of the sheet_properties (Ctrl+Shift+S)

HTH

[#7]

Thanks guys!