Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ange1234
Contributor II
Contributor II

How to specify which sheet in the excel file should be opened as first using button in QlikView?

Hello there!

I have created a button that opens an excel file (Actions -> Open URL).

It works but... The things is that there is several sheets in my file and I want to set only one that will always be opened as first. How can I specify a default sheet?

All the best,

Angelika

1 Solution

Accepted Solutions
marcus_sommer

I think it's not possible - at least not with this approach. If you call a vbs-macro with your button which opens the Excel it could afterwards switch to your defined sheet.

Another method may be to implement an OnOpen macro within the Excel which queries the accessing user and switched then to your wanted sheet.

- Marcus 

View solution in original post

2 Replies
marcus_sommer

I think it's not possible - at least not with this approach. If you call a vbs-macro with your button which opens the Excel it could afterwards switch to your defined sheet.

Another method may be to implement an OnOpen macro within the Excel which queries the accessing user and switched then to your wanted sheet.

- Marcus 

ange1234
Contributor II
Contributor II
Author

Thank you for the hints.