Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro to switch between Sheets

I need a macro that every 1 minute to switch between nine worksheets, creating a panel, can someone show me an example? That the application must also update their data after a load on the QlikView Server, updating the browser ... Thanks

2 Replies
Alejandro_Hernández
Former Employee
Former Employee

Here's a very simple macro that switches between sheets:

Sub SwitchTab
For x = 0 to 5
ActiveDocument.ActivateSheet x
ActiveDocument.GetApplication.Sleep 1000
ActiveDocument.GetApplication.WaitForIdle                    
next
End Sub

Not applicable
Author

Thanks for the help, but I need to do something a little more complex, the macro must select each item in a list every 30 seconds and when finish the list items, change the tab, I need to put a specific name for this function it triggers the open QVW? Thanks