topic Detaching Sheet in QlikView

Detaching Sheet

prabhu0505 — Thu, 29 Apr 2010 08:38:11 GMT

Is it possible to detach a sheet from the document?

Regards,

Prabhu

Detaching Sheet

prabhu0505 — Thu, 29 Apr 2010 12:12:32 GMT

any idea?

Detaching Sheet

amars — Thu, 29 Apr 2010 12:17:28 GMT

Hi Prabhu,

I don't know about detaching the sheet but you can hide the sheet by going in Sheet Properties->General->Show Sheet -> Conditional & put a formula over here for conditional hiding of the sheet(i.e u can make use of a variable also to show it or hide)

With Regards

Amar

Detaching Sheet

prabhu0505 — Thu, 29 Apr 2010 12:45:05 GMT

Thanks for your reply, Amar.

But I'm looking for detaching or isolating a sheet.

This I thought of doing by loading(aliasing) new fields from the existing fields, but I dont whether it will take additional memory, so I stand there.

Any views?

Detaching Sheet

Thu, 27 Jan 2011 10:24:21 GMT

HI. You could do a macro that Deactives every Sheet object in the Sheet you want to isolate.

Detaching Sheet

kuba_michalik — Thu, 27 Jan 2011 12:23:42 GMT

Do you mean detaching as in detaching an object (it will "freeze" at its current state, i.e. further selections will not modify its state until it is attached again) or as in making a sheet fully independent (sheet is oblivious to selections made on other sheets, and likewise other sheets do not react to selections made on the isolated sheet)?

Detaching Sheet

Thu, 27 Jan 2011 16:57:27 GMT

I need some help with making the sheet as you said "fully independent". I got one tab/sheet that I dont want to reflect the selections made on other sheets and vise versa.

Any idea on how to solve this?

Detaching Sheet

Thu, 27 Jan 2011 17:10:30 GMT

You could use triggers and macro... See the API Guide..

Detaching Sheet

matt_crowther — Thu, 27 Jan 2011 17:22:40 GMT

a) There will be a vb Macro based solution to this; somehthing involving 'GetSheetObjects', a loop and 'Detach' no doubt...but sadly my vb skills don't stretch that far - someone like Rob 'The Wonder' Wuderlich could do it in their sleep: he's an Obi Wan to my Wedge Antilles (or Jar Jar Binks!?)

b) As a half-way solution: set Triggers on activation and de-activation of the sheet you wish to detach to 'Clear all Selections' that way as soon as you enter or leave the 'detached' sheet all previous selections will be removed creating the illusion of detachment.

Hope that helps,

Matt - Visual Analytics Ltd