Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In the Triggers tab of the Sheet properties, create an Action to Clear All selections on activate of the sheet.
Regards,
Stephen
Hi Asad,
Think better use set analysis by it we hard code it . but not sure abt ur needs...
In the Triggers tab of the Sheet properties, create an Action to Clear All selections on activate of the sheet.
Regards,
Stephen
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
Thanks all for your replies.
Is it possible to detach a whole sheet?
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....
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
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 !!
Hi Josue,
Not sure about your specific requirement, but selection triggers did help in my case.
KRs/
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.