select a specific sheet

[ali_hijazi]

Hello

is there a way to force the document to select a specific sheet upon opening the qlikview document?

if yes will this be applied or will still be applicable when the document is opened via web-browser from the access point?

[kaushiknsolanki]

Hi,

    You can use the On Open trigger of Qlikview to activate the specific sheet on opening the document.

    Go to Settings-> Document Properties-> Triggers->

    Here add trigger to activate the sheet.

    This should also work in browser.

Regards,

Kaushik Solanki

[#3]

hi,

You can use this macro:

ActiveDocument.ActivateSheet "SH01"

or u can use the example of Kaushik.

But if you want open a document always with the same sheet u can save the file with that sheet opened.

You can find examples of macro in ApiGuide.qvw

I hope this helps you.

C u,

Stefano.

[ali_hijazi]

I added a trigger to the ONOpen

however this trigger doesn't work when the document is open in the web browser

[kaushiknsolanki]

Hi,

On a Server environment, the OnOpen trigger shouldn't work by design (it's not a flaw and it's documented). Check the Reference Manual, section 29.3 Macro trigger limitations. However, those actions are likely to work if you use them in a button, or when activating a sheet.

Hope this helps.

Regards,

Kaushik Solanki

[Miguel_Angel_Baeyens]

Yep, that sounds correct.

[ali_hijazi]

ok then

can I make all sheets hidden and keep only welcome screen with an ENTER button

when the user clicks this button I run the triggers on the ONOPEN even on the click event of the button and make the rest of the sheets visible?

please advise

this should occur everytime the user opens the document

[Miguel_Angel_Baeyens]

Hi,

You can hide the tabrow, in the Settings menu, Document Properties. Then you can create a menu (buttons, text objects) with actions to activate a given sheet, so the user doesn't see all the tabs in every moment, only the menus and can only browse those tabs where the buttons (menu) allow him to move.

You can set as well all sheets hidden by default, using a variable vHideSheet in the conditional, set this variable to 0, and create a button in the welcome sheet that sets this variable to 1 so the condition in the General tab

vHideSheet = 1

becomes true and shows all sheets.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[rwunderlich]

You can save the document with the desired sheet as the active sheet. It should open to that sheet each time.

-Rob

[#10]

You did not specify if you're using the IE plugin or AJAX interface to access the document. If you're using the IE plugin, then you can triggers. If you're using AJAX, the on open trigger does not work since the on open trigger does not correspond to the page render in the browser. The best way is to simply save the document with your sheet active as Rob suggested. If that's not possible, then you can add the following code right after the qva,_Send call in opendoc.htm:

            qva.SetInitial("Document.TabRow.Document\\<sheet id>", "action", "");

where <sheet id> is the id of the sheet you want active. Of course this change affects all documents.