detaching automatically...

[#1]

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,

[pover]

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.

[#3]

Hi Karl,

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

Thanks,

[pover]

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

[JCMMSANTANDER]

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