topic Re: Default Sheet in QlikView

Default Sheet

Mon, 09 Mar 2015 10:28:43 GMT

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?

Re: Default Sheet

alex_millan — Mon, 09 Mar 2015 10:30:46 GMT

Hi,

Go to:

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

Regards.

Re: Default Sheet

chrislofthouse — Mon, 09 Mar 2015 10:32:04 GMT

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

Re: Default Sheet

maleksafa — Mon, 09 Mar 2015 10:32:05 GMT

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

Re: Default Sheet

awhitfield — Mon, 09 Mar 2015 10:32:17 GMT

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

Re: Default Sheet

datanibbler — Mon, 09 Mar 2015 10:33:36 GMT

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

Re: Default Sheet

Mon, 09 Mar 2015 10:34:37 GMT

Thanks guys!