topic Previously viewed sheet in App Development

Previously viewed sheet

alice — Tue, 03 Sep 2024 08:41:36 GMT

Hello everyone.
New here...
how to set up a button that allows you to return to the previously viewed sheet?
Thanks for your help

Re: Previously viewed sheet

Maria_Halley — Tue, 03 Sep 2024 10:38:31 GMT

@alice

There is a button object, under charts, this can be configured to do that.

Re: Previously viewed sheet

alice — Tue, 03 Sep 2024 11:04:18 GMT

Thanks @Maria_Halley but i wanted to know how to get the value (id, link...) of the previously viewed sheet...

Re: Previously viewed sheet

Ruan_Sasse — Tue, 03 Sep 2024 11:15:57 GMT

In Qlik Sense, you create a new tab and select 'Edit Sheet.' On the left side, there's a 'Charts' option. Click on it, select the 'Button' option, and drag it onto the screen. Select the button, and on the right side, the button's editing options will appear. Under 'Actions and Navigation,' there's a 'Navigation' option, where you'll find several navigability options.

Re: Previously viewed sheet

alice — Tue, 03 Sep 2024 11:28:45 GMT

I apologize, I should have been more specific -
indeed, there are options in 'Actions and Navigation' but I don't see the one to go to the 'previously viewed sheet' - I only see the option 'go to the previous sheet'. Hence my idea of recovering this data in a variable but I don't know which function to use

Re: Previously viewed sheet

Ruan_Sasse — Tue, 03 Sep 2024 14:19:17 GMT

I understand that this is a more specific task. You would need to use the 'Go to Sheet' option defined by the Sheet ID. However, to get the ID from the URL, you would have to use some extension or mashup. I'm not sure how to do this myself, but perhaps someone else here knows and can provide a solution.

For example, in the URL ...e794/sheet/CLLkk/state/edit, CLLkk is the Sheet ID.

Re: Previously viewed sheet

alice — Thu, 05 Sep 2024 09:27:10 GMT

Solution found

Insert a button on the sheets with:
* Action: Set the value of a variable (Variable: vPreviousSheet and Value = ObjectID('sheet'))
* Navigation: Access a sheet ('target' sheet)

On the 'target' sheet; insert a button with:
* Navigation: Access a sheet (='$(vPreviousSheet))

It works in my case...

If it can be useful to someone...