activate previous viewed sheet

[kristof_j]

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

[Anil_Babu_Samineni]

Why not Macro

ActiveSheet.Previous.Select

[kristof_j]

I'm not very familiar with macro's.

Can you give an example?

[Siva_Sankar]

Kristof,

See here Go to Previous Active Sheet without using macro.

Thanks,

Siva

[kristof_j]

and with a macro? 🙂

[Siva_Sankar]

Kristof,

Find the attachment to activate the sheet with macro.

Siva

[Siva_Sankar]

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]

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]

Hi Kristof,

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

Siva