topic Re: How to detach a sheet object from sheet?? in QlikView

How to detach a sheet object from sheet??

priyav24 — Wed, 03 Jul 2013 13:06:50 GMT

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

Re: How to detach a sheet object from sheet??

Gysbert_Wassenaar — Wed, 03 Jul 2013 13:11:08 GMT

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.

Re: How to detach a sheet object from sheet??

IAMDV — Wed, 03 Jul 2013 13:46:43 GMT

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,

www.QlikShare.com

Re: How to detach a sheet object from sheet??

priyav24 — Thu, 04 Jul 2013 05:34:42 GMT

Thank you so much Gysbert.....

Re: How to detach a sheet object from sheet??

priyav24 — Thu, 04 Jul 2013 05:35:05 GMT

Thank you Deepak

Re: How to detach a sheet object from sheet??

Anonymous — Mon, 09 Nov 2015 22:12:12 GMT

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