remove Link between sheets

[#1]

Hello Everybody,

Is there any way to unlink sheets in the same document. Currently, when i make a selection on one sheet, it reflects on all the sheets in that document. But i want to do separate selections for every sheet.

Please advise.

Thanks & BRs,

Asad

[IAMDV]

Please can you share the QV document as an example? This will be very helpful!

[Miguel_Angel_Baeyens]

Hello,

Check this post and its thread.

Hope that helps.

[#4]

That's it, much better than I did.

Thanks, Miguel !

[#5]

Hi Miguel,

I have gone through ur provided link. I think thats the perfect way of getting the desired result, but i don't know what I am doing wrong, somehow, the bookmarks are not being applied/replaced on activate and leave sheets. is there any special expression to call the bookmark in the trigger or just the bookmark ID is enough? Can you share some screenshots of what options to select while adding a bookmark and how does an exression in a trigger look like?

Appreciate your time and patience:)

KRs/Asad

[#6]

I don't know if that's your case, but I mistook the name of the BookMark with its ID. The ID of them you can check in Bookmarks -> More... That's the string you use in the trigger fo the Sheet.

[#7]

This forum is the best 😄

Thanks Josu'e

[Miguel_Angel_Baeyens]

Hello Assad,

I try to avoid macros as often as I can, and this is one case. I'm using actions in the Sheet properties, Triggers tab, OnActivateSheet and OnLeaveSheet, using Action type Bookmark, Clear All, Apply Bookmark (OnActivate) and Replace Bookmark (OnLeave).

Bookmarks must exist previous to execute the actions (they are triggered when you click on another sheet tab), although bookmarks can be empty (no need to select anything when storing them).

Hope that helps.

[#9]

Thanks for the guidelines Miguel, u r the best:)

[#10]

Hi Asad,

I am new to Qlikview and was looking for an answer to the same question - looks like the right answer has come from stephen.redmond.. Are you using this solution? And which version of Qlikview are you using?

I ask because I found another answer in http://www.qlikblog.at/779/qliktip-26-introducing-linked-objects-qlikview-10/ - which seems imply that unlinking should be a standard feature in Qlickview10 -  however have not been able to locate the Unlink option in the context menu of the objects although I am running Qlickview10 myself... Any views on this option?. /br nlj

[#11]

Hi Miguel

I had implemented this method as you suggested, adding the bookmarks then adding the relevant triggers. This did work fine. But now on the Ajax client it has stopped working.

The replace bookmark does not seem to work when you leave the sheet, so when a sheet is re-activated it just loads the bookmark which was set before I deployed the document to the server.

I cannot work out why it has stopped working, if you have any ideas why that would be great.

many thanks

nick