Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Highlighted

Why not Macro

ActiveSheet.Previous.Select

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)
Highlighted
Creator II
Creator II

I'm not very familiar with macro's.

Can you give an example?

Highlighted
Master II
Master II

Kristof,

See here Go to Previous Active Sheet without using macro.

Thanks,

Siva

Highlighted
Creator II
Creator II

and with a macro? 🙂

Highlighted
Master II
Master II

Kristof,

Find the attachment to activate the sheet with macro.

Siva

Highlighted
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

Highlighted
Specialist III
Specialist III

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

Highlighted
Master II
Master II

Hi Kristof,

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

Siva