topic Initial Sheet (Opening Sheet) in QlikView

Initial Sheet (Opening Sheet)

Anonymous — Tue, 25 Oct 2011 19:05:44 GMT

I want the users to land on a specific sheet when opening using any client from the access point. I have saved the file on the sheet I want to open, but there appear to be users on the AJAX client where the document opens to a different sheet every time. Is there a cache or some other AJAX limitation that is preventing this from working correctly? Is there another way to accomplish this?

Initial Sheet (Opening Sheet)

m_woolf — Tue, 25 Oct 2011 19:36:02 GMT

Try:

ActiveDocument.Sheets("Details").Activate

in a macro that is set yo run when the document is opened, where Details is the name of the sheet you want to activate.

Initial Sheet (Opening Sheet)

Anonymous — Tue, 25 Oct 2011 19:46:01 GMT

I will certainly try that. So it looks like a possibility is that AJAX cannot process activate sheet on open triggers but can execute a macro that does the same thing? I will post results.

Initial Sheet (Opening Sheet)

erichshiino — Tue, 25 Oct 2011 20:00:39 GMT

Hi, Aaaron,

Maybe those users are recovering an old session.

You can try to disable it on the server.

There is a checkbox called 'Prohibit Session Recovery' on the Documents tab in Server properties in QEMC. Please, check if it marked. It may be causing your problem.

Hope this helps,

Erich

Initial Sheet (Opening Sheet)

Anonymous — Wed, 26 Oct 2011 16:13:43 GMT

The macro idea worked.