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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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

Labels (1)
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