topic remove Link between sheets in QlikView

remove Link between sheets

Fri, 04 Mar 2011 10:48:45 GMT

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

remove Link between sheets

Fri, 04 Mar 2011 10:51:54 GMT

Hi Asad,

Think better use set analysis by it we hard code it . but not sure abt ur needs...

remove Link between sheets

stephencredmond — Fri, 04 Mar 2011 10:51:59 GMT

In the Triggers tab of the Sheet properties, create an Action to Clear All selections on activate of the sheet.

Regards,

Stephen

remove Link between sheets

IAMDV — Fri, 04 Mar 2011 10:58:13 GMT

Asad - Because you have loaded the data in Qlikview and with the associative search model. You have 3 options...

1. You can detach the invidual objects, so they are not dependant on selection from other sheets

2. Import the data as seperate dataset as an abstraction layer

3. Use Set Analysis / Triggers

remove Link between sheets

Fri, 04 Mar 2011 11:47:33 GMT

Thanks all for your replies.

Is it possible to detach a whole sheet?

remove Link between sheets

amars — Fri, 04 Mar 2011 13:33:26 GMT

Hi Asad,

You can create a variable vHideShow in variables & can use it in Sheet Properties Show -> Conditional & can set or reset the value of the variable using a macro, which can be triggered on any action like button click.

function getVariable(varName)

set v = ActiveDocument.Variables(varName)

getVariable = v.GetContent.String

end function

Sub Hide_Show_Sheet

strHideShow = getvariable("vHideShow")

if strHideShow = "1" Then

set varHideShow = ActiveDocument.GetVariable("vHideShow")

varHideShow.SetContent "0",true

else

set varHideShow = ActiveDocument.GetVariable("vHideShow")

varHideShow.SetContent "1",true

End if

End Sub

Thanks....

remove Link between sheets

Fri, 04 Mar 2011 14:29:33 GMT

Thanks Amars,

Your guidlines helped me in another case, however, I want the sheet to be visible but the selections in the sheet should not be updated by making any changes in the other sheets. Thats why i want to detach/unlink the specific sheet from others.

KRs/Asad

remove Link between sheets

Thu, 24 Mar 2011 19:35:31 GMT

I have the same problem here. I also don't want to lost the selections made in the other sheets when I click in the "detached" sheet. With Triggers I cannot do that.

Any more suggestions ??

Thanks !!

remove Link between sheets

Fri, 25 Mar 2011 10:07:59 GMT

Hi Josue,

Not sure about your specific requirement, but selection triggers did help in my case.

KRs/

remove Link between sheets

Fri, 25 Mar 2011 11:46:25 GMT

Hi Asad,

I found a solution. I used bookmarks for each sheet, to save its selections. So, when I leave a sheet, I replace a bookmark for it and make a clean in all selections. When I activate a sheet, I make the clean and apply its bookmark.

I hope this solution help someone.

remove Link between sheets

IAMDV — Fri, 25 Mar 2011 11:55:25 GMT

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

remove Link between sheets

Miguel_Angel_Baeyens — Fri, 25 Mar 2011 12:11:19 GMT

Hello,

Check this post and its thread.

Hope that helps.

remove Link between sheets

Fri, 25 Mar 2011 12:31:27 GMT

That's it, much better than I did.

Thanks, Miguel !

remove Link between sheets

Fri, 25 Mar 2011 13:33:25 GMT

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

remove Link between sheets

Fri, 25 Mar 2011 13:40:11 GMT

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.

remove Link between sheets

Fri, 25 Mar 2011 13:49:45 GMT

This forum is the best 😄

Thanks Josu'e

remove Link between sheets

Miguel_Angel_Baeyens — Fri, 25 Mar 2011 13:55:51 GMT

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.

remove Link between sheets

Fri, 25 Mar 2011 14:06:15 GMT

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

remove Link between sheets

Wed, 22 Jun 2011 08:33:04 GMT

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

remove Link between sheets

Wed, 02 Nov 2011 17:17:12 GMT

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