topic Re: detaching automatically... in QlikView

detaching automatically...

Sat, 09 Oct 2010 12:36:12 GMT

Hi,

I have a dashboard with Multi box with the name of A, list box with the name of B, 2 graph charts. C & D.

If I change any value in the A, the rest of the list box (B), C & D are changing automatically.

But my requirement is if I change anything in the A only C & D has to change not B.

Suppose if I change list of values in the B only C has to change rest A & D not supppose to change.

Is this kind option is there in 8.2 version??

And I don't want do detach and attach.

Thanks,

detaching automatically...

pover — Sat, 09 Oct 2010 16:46:31 GMT

In 8.2, I think the only options were to create table islands and sum if statements to do such a configuration.

Based on the post title, you could also detach everything and only attach certain objects according to the selection in each field that triggers different macro with the functions:

ActiveDocument.GetSheetObject("CH01").Detach
ActiveDocument.GetSheetObject("CH01").Attach

I assume these functions exist in the 8.2 version.

Regards.

detaching automatically...

Fri, 22 Oct 2010 08:10:12 GMT

Hi Karl,

Could you pls let me know how to use these functions in the dashboards.

Thanks,

detaching automatically...

pover — Fri, 22 Oct 2010 21:38:12 GMT

See the attached example. The marco is in "Tools->Edit Modulo..." The funny thing is that the functions I gave you above didn't work in Qlikview 10 so I changed the marco to the following which worked just fine. Regards.

sub detach

set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties
p.Detached = true
chart.SetProperties p

end sub

sub attach

set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties
p.Detached = false
chart.SetProperties p

end sub

Re: detaching automatically...

JCMMSANTANDER — Fri, 28 Jun 2019 14:16:32 GMT

Useful with tables (Pivot or Straight) with high number of lines:

sub TBL_Atach_Detach

set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties
p.Detached = not p.Detached
chart.SetProperties p

end sub

Thanks

Juan