Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to navigate to the last accessed sheet from the current sheet using single button object.
For example I am coming to a current sheet from different sheets(either sheet 1 , sheet 2, sheet 3) using navigation option on button object...now I want to go to last accessed sheet from current sheet using single button object only.
Is there any kind of function or field available in Qliksense which is storing sheet names and sheet ids?
Your suggestions are welcome.
Aatish
Hello,
If my understanding is correct, then you have multiple sheets and on each sheet you want to put a Button that when clicked is going to navigate you to the previous sheet that you were active on. For example, if you are on Sheet 1 and then you go to Sheet 2, clicking the button on Sheet 2 will navigate you to Sheet 1 and then clicking the button on Sheet 1 will navigate you to Sheet 2. In case I missed something please elaborate in detail to the use case scenario of the issue.
This is currently not possible to achieve with 100% functionality, but there is a workaround that you can use. The reason why it is not possible to achieve with 100% functionality, is because currently there is no any function available that can give you the current active sheet ID. You can however achieve some similar behavior by following the steps below:
Lets assume that we have 3 different sheets:
Then you should follow the steps:
What this does, whenever you click a button on the sheet, it will navigate to the sheet based on the value that is last saved and at the same time it will update the value with the sheet ID that you specified which means it will always save the sheet ID of the last visited sheet. If you rely solely on this workaround, you will notice that it doesn't work 100% of the time, however is the closest you can get to your use case scenario.
Further explanation of what this will do:
There is a pending Feature Request [1] regarding having a function that will return the active sheet's ID, which will replace the section where you specify the exact sheet ID when updating the variable in the action, so you can upvote the idea and put your own comments to support it. However, if you would like to have this functionality natively, without having to do the workaround, you can create a new Feature Request [2].
I hope that this information was helpful
---
Hello,
If my understanding is correct, then you have multiple sheets and on each sheet you want to put a Button that when clicked is going to navigate you to the previous sheet that you were active on. For example, if you are on Sheet 1 and then you go to Sheet 2, clicking the button on Sheet 2 will navigate you to Sheet 1 and then clicking the button on Sheet 1 will navigate you to Sheet 2. In case I missed something please elaborate in detail to the use case scenario of the issue.
This is currently not possible to achieve with 100% functionality, but there is a workaround that you can use. The reason why it is not possible to achieve with 100% functionality, is because currently there is no any function available that can give you the current active sheet ID. You can however achieve some similar behavior by following the steps below:
Lets assume that we have 3 different sheets:
Then you should follow the steps:
What this does, whenever you click a button on the sheet, it will navigate to the sheet based on the value that is last saved and at the same time it will update the value with the sheet ID that you specified which means it will always save the sheet ID of the last visited sheet. If you rely solely on this workaround, you will notice that it doesn't work 100% of the time, however is the closest you can get to your use case scenario.
Further explanation of what this will do:
There is a pending Feature Request [1] regarding having a function that will return the active sheet's ID, which will replace the section where you specify the exact sheet ID when updating the variable in the action, so you can upvote the idea and put your own comments to support it. However, if you would like to have this functionality natively, without having to do the workaround, you can create a new Feature Request [2].
I hope that this information was helpful
---
Yes Andrei,
I handled this situation with variable and sheet id
Thanks for the help. It solved my issue.
Best regards,
Aatish
Hi Aatish,
I'm trying to do something similar, although I'm having trouble with the navigation action accepting the contents of my variable as a valid sheet ID.
For example, Sheet 1 action, set variable vWhatSheet = '6a3cfae8-c274-4aec-a420-7896439459fd'.
Sheet 2 Back button action Go to Sheet Defined by Sheet ID = $(vWhatSheet).
However this doesn't work. When I expand the function box I'm getting an error message about 'Garbage after a3cfae8'
However, when I added a 'static' button using just the sheet ID string, it works fine.
Would you mind sharing how you got this to work? Any help would be most appreciated.
Matt
in facts, it doesn't works as described.
It seems you can't go to a sheet using a variable in this way:
='$(IdSheet)'
It works only in this way:
='b4930339-a7de-409a-a9de-85022025dd8d'