topic select a specific sheet in QlikView

select a specific sheet

ali_hijazi — Tue, 04 Oct 2011 09:01:45 GMT

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?

select a specific sheet

kaushiknsolanki — Tue, 04 Oct 2011 09:08:08 GMT

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

Re: select a specific sheet

Tue, 04 Oct 2011 09:11:32 GMT

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.

select a specific sheet

ali_hijazi — Tue, 04 Oct 2011 10:14:49 GMT

I added a trigger to the ONOpen

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

select a specific sheet

kaushiknsolanki — Tue, 04 Oct 2011 10:15:42 GMT

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

Re: select a specific sheet

Miguel_Angel_Baeyens — Tue, 04 Oct 2011 10:28:26 GMT

Yep, that sounds correct.

select a specific sheet

ali_hijazi — Tue, 04 Oct 2011 10:47:46 GMT

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

Re: select a specific sheet

Miguel_Angel_Baeyens — Tue, 04 Oct 2011 11:06:47 GMT

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

select a specific sheet

rwunderlich — Wed, 05 Oct 2011 00:24:20 GMT

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

-Rob

select a specific sheet

Wed, 05 Oct 2011 00:45:37 GMT

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.

Re: select a specific sheet

Thu, 03 Jan 2013 13:49:57 GMT

Hi Ali,

We have a similar scenario where in we use a Macro which works OnOpen.

We need to access querystring from URL and refresh the dashboard using this parameter.

This works fine in the local desktop but is failing while publishing in the server.

Do you have any idea of activating the sheet on web page load as you seem to face similar kind of issue.

Please let me know if you have any solution.

Thanks

Sai

Re: select a specific sheet

rwunderlich — Thu, 03 Jan 2013 19:51:39 GMT

If you are uisng the Ajax client, youcan add a sheet parameter onto the URL which will take you to the specified sheetId.

&sheet=SH10

-Rob

Re: select a specific sheet

Fri, 04 Jan 2013 12:48:41 GMT

Hi Rob,

Thanks for your response.

We tried the way you mentioned as well but we came to know that there is a limitation in QV for the triggers.

OnReload, OnOpen and OnPostReload macros will not work when the document is on the server was the response in the below link from Miguel.

http://community.qlik.com/thread/32890?tstart=0#138063

Can you please suggest any other alternates to activate the sheet and reload the dashboard?

Thanks

Sai Krishna