How to detach a sheet object from sheet??

[priyav24]

Hello Everybody,

                              I have a requirement that sheet object should be detached from the sheet

                              That is,the particular sheet object should remain static,it should not get  affected by any selections that where made in the sheet.

                              I done this by detaching the sheet object from the sheet.

                              But, the problem is when i close  and reopen the qvw file the sheet object which i detached from sheet gets attached to the sheet.

                              Is there any Solution for detaching the sheetobject permanently..

Thanks In Advance,

Priya

[Gysbert_Wassenaar · Accepted solution]

In QV11 you can use alternate states for this. On the General tab of the document properties window you can create a new alternate state. After creating it you can assign it on the General tab of the sheet object to that object. Only selections made in the same alternate state will affect the sheet object. So as long as you don't assign that alternate state to other objects the sheet object will act independently of the rest of the document.

[IAMDV]

Hi Priya,

You can use what Gysbert suggested. Also, there are two more ways:

1. Set Analysis Approach

2. Macro (On Document Open Trigger)

Please see the attachment and let me know if you need further help. I hope this helps!

Good luck!

Cheers,

DV

www.QlikShare.com

[priyav24]

Thank you so much Gysbert.....

[priyav24]

Thank you Deepak

[Anonymous]

Hi

I created an alternate state in document properties and added it in chart properties , still the chart is not detached can I know where I am going wrong ?

Thanks