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

[#2]

Hi Asad,

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

[stephencredmond · Accepted solution]

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

Regards,

Stephen

[IAMDV]

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

[#5]

Thanks all for your replies.

Is it possible to detach a whole sheet?

[amars]

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....

[#7]

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

[#8]

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 !!

[#9]

Hi Josue,

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

KRs/

[#10]

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.