Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kristof_j
Creator III
Creator III

activate previous viewed sheet

Hi

I want to create a button that activates the previous viewed sheet.

So not the action 'Activate Previous Sheet' which activates the sheet on the left.

I found this post https://community.qlik.com/thread/73311 but is there a more elegant way that is easier to implement?

thanks in advance

8 Replies
Anil_Babu_Samineni

Why not Macro

ActiveSheet.Previous.Select

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kristof_j
Creator III
Creator III
Author

I'm not very familiar with macro's.

Can you give an example?

Siva_Sankar
Master II
Master II

Kristof,

See here Go to Previous Active Sheet without using macro.

Thanks,

Siva

kristof_j
Creator III
Creator III
Author

and with a macro? 🙂

Siva_Sankar
Master II
Master II

Kristof,

Find the attachment to activate the sheet with macro.

Siva

Siva_Sankar
Master II
Master II

Press Ctrl + M to see the macro code.

previously accessed sheet id was captured and will be stored in a variable.

Macro will get the sheet id and activate on hittng the button.

Siva

Anonymous
Not applicable

Hi Kristof,

Create a variable like vPrevSheet, and create an action when you leave the sheet with the sheet ID.

With a button you can activate the sheet saved on the variable.

Regards!!!

Siva_Sankar
Master II
Master II

Hi Kristof,

If you got the solution, ,can you mark it as correct answer and close this thread?

Siva