topic Re: Bookmarks to take to another sheet in QlikView

Bookmarks to take to another sheet

Tue, 09 Dec 2014 07:49:12 GMT

In addition to recreate your selections, can a bookmark take you to another sheet, as to where the bookmark was created?

If not, what alternative method can do this?

Re: Bookmarks to take to another sheet

maleksafa — Tue, 09 Dec 2014 07:54:22 GMT

i don't think it is possible, as the bookmarks only set your selection, one alternative is to add a button with two actions, the first one is to select the bookmark and the second one will take you to the sheet that you want.

Re: Bookmarks to take to another sheet

MK_QSL — Tue, 09 Dec 2014 07:55:59 GMT

Right Click

New Sheet Object

Button

Actions Tab

Add

Layout

Activate Next Sheet

Activate Sheet

Sheet ID

Mention the ID of Sheet which you want to activate after clicking on this button

Sheet ID, you can get by

Right Click empty space of any sheet

Sheet ID is mentioned on TOP RIGHT corner

Re: Bookmarks to take to another sheet

Tue, 09 Dec 2014 07:57:58 GMT

Thanks Malek

Just thought I could do it with Bookmarks somehow.

Re: Bookmarks to take to another sheet

simenkg — Tue, 09 Dec 2014 08:05:15 GMT

Yes it can.

When you create a bookmark, check the "include layout state" checkbox. It will then take you to the active sheet and the activated object.

Re: Bookmarks to take to another sheet

Tue, 09 Dec 2014 08:09:16 GMT

Thanks for your response Simen. But unfortunately it doesn't. Unless there's something else Im missing.

I've ticked the "Include Layout" checkbox, but it does not take me to the appropriate sheet.

Re: Re: Bookmarks to take to another sheet

simenkg — Tue, 09 Dec 2014 08:12:53 GMT

I just tested it in a random model and it should work fine.

See the attached file.

Re: Bookmarks to take to another sheet

mangalsk — Tue, 09 Dec 2014 08:15:13 GMT

Hello,

also check 1st option 'make this bookmarka document bookmark' and it works

Re: Re: Bookmarks to take to another sheet

simenkg — Tue, 09 Dec 2014 08:23:27 GMT

Seems like it is not possible when creating a bookmark as a user in Accesspoint, but when you create a document bookmark from the desktop version it works as intended even in accesspoint.

I leave it to someone else to test in the IE-plugin.

Re: Bookmarks to take to another sheet

Tue, 09 Dec 2014 08:23:28 GMT

Yes you're right Simen. I've tried it again and it takes me to the sheet. But I notice that it doesn't remember by objects' visibility/invisibility. I have some buttons on the sheet which hides and shows different objects. These dont get reselected by the Bookmark.

Re: Bookmarks to take to another sheet

Tue, 09 Dec 2014 08:29:24 GMT

It works with IE Plugin as well. The only thing (like I said above), is that is doesn't regenerate your hidden/visible objects on the sheet.

Re: Bookmarks to take to another sheet

simenkg — Tue, 09 Dec 2014 08:33:55 GMT

You can change the conditions for showing and hiding and you can make it work.

If you use a data island approach instead of using variables then you can recreate it.

The way you do it is that you create a "on/off" field in a table with no connections to your data model. Then you test on which selection in that table is made. You can make selections in this table using buttons and you will have mostly the same functionality.

Re: Bookmarks to take to another sheet

Tue, 09 Dec 2014 08:44:24 GMT

Thank you Simen. I'll give that a go!

Appreciating your contribution.