Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

kristof_j
Contributor II

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

Re: activate previous viewed sheet

Why not Macro

ActiveSheet.Previous.Select

kristof_j
Contributor II

Re: activate previous viewed sheet

I'm not very familiar with macro's.

Can you give an example?

shankarece
Honored Contributor

Re: activate previous viewed sheet

Kristof,

See here Go to Previous Active Sheet without using macro.

Thanks,

Siva

kristof_j
Contributor II

Re: activate previous viewed sheet

and with a macro? :-)

shankarece
Honored Contributor

Re: activate previous viewed sheet

Kristof,

Find the attachment to activate the sheet with macro.

Siva

shankarece
Honored Contributor

Re: activate previous viewed sheet

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

manucamon
Valued Contributor III

Re: activate previous viewed sheet

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!!!

shankarece
Honored Contributor

Re: activate previous viewed sheet

Hi Kristof,

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

Siva