Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
Hi Karl,
Could you pls let me know how to use these functions in the dashboards.
Thanks,
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
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