Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
krish2459
Creator
Creator

How to activate previous viewed sheet in qliksense

Hi,

 

How to activate previous viewed sheet in qliksense using  button.

 

Thanks..

Labels (1)
5 Replies
Tanalex
Creator II
Creator II

Choose BUTTON object, no need for an action, then choose the navigation you want.

Button.png

krish2459
Creator
Creator
Author

Hi,

This option lead to previous sheet.

But we need to navigate the option to go for previously opened sheet.

Thanks,

Krish

pover
Luminary Alumni
Luminary Alumni

Hi, 

Do the following to implement the button to go to back to the sheet you had previously been.

  1. Create a variable called v_PreviouslyVisitedSheet
  2. Set up a sheet action for each sheet to set a variable and set the value to =v_PreviouslyVisitedSheet & '|360530e7-fcf1-4450-9d8f-b56134672b2f' where the GUID is the current sheet ID from the URL.

 

pover_0-1681871414135.png

 

  1. Create a master item button and place it on each sheet. The button has the action to ‘Go to sheet’ and define the sheet as =subfield(v_PreviouslyVisitedSheet, '|', -1)

Best, Karl

justalkak
Partner - Contributor III
Partner - Contributor III

Actually Povers solution works perfectly well. The only mistake is it should be 1, not -1 here: =subfield(v_PreviouslyVisitedSheet, '|', 1).

robert99
Specialist III
Specialist III

This solution worked for me. But I changed it around a bit

Step 1 Set up a Variable in script 

robert99_0-1700003817936.png

Or

Set up a variable using Edit Sheet then variable (both work)

robert99_4-1700005457583.png

Step 2. Must do in every sheet that Users might want to return to

robert99_1-1700004068057.png

=right(vPrevVisitedSheet & '|50783425-740f-4784-9288-a84129f547e9' ,120)

where 50783425-740f-4784-9288-a84129f547e9 = the current sheet ID

Step 3

A button in every sheet as required (copy and paste)

 

robert99_2-1700004377213.png

=subfield(vPrevVisitedSheet, '|', -2)