Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
aaroncouran
Creator III
Creator III

Initial Sheet (Opening Sheet)

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?

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

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.

View solution in original post

4 Replies
m_woolf
Master II
Master II

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.

aaroncouran
Creator III
Creator III
Author

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.

erichshiino
Partner
Partner

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

aaroncouran
Creator III
Creator III
Author

The macro idea worked.