topic Re: activate previous viewed sheet in QlikView

activate previous viewed sheet

kristof_j — Mon, 22 Aug 2016 08:06:34 GMT

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 — Mon, 22 Aug 2016 08:12:30 GMT

Why not Macro

ActiveSheet.Previous.Select

kristof_j — Mon, 22 Aug 2016 08:17:00 GMT

I'm not very familiar with macro's.

Can you give an example?

Siva_Sankar — Mon, 22 Aug 2016 08:24:43 GMT

Kristof,

See here Go to Previous Active Sheet without using macro.

Thanks,

Siva

kristof_j — Mon, 22 Aug 2016 08:46:07 GMT

and with a macro? 🙂

Siva_Sankar — Mon, 22 Aug 2016 09:08:32 GMT

Kristof,

Find the attachment to activate the sheet with macro.

Siva

Siva_Sankar — Mon, 22 Aug 2016 09:21:17 GMT

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 — Mon, 22 Aug 2016 09:28:18 GMT

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 — Mon, 22 Aug 2016 12:38:39 GMT

Hi Kristof,

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

Siva