topic Clear Filter Macro Triggered by Container Tab Change - Please help in QlikView

Clear Filter Macro Triggered by Container Tab Change - Please help

Thu, 11 Feb 2016 03:31:27 GMT

Hi, I would appreciate assistance on building a macro that runs when the container tab is changed. The macro would unfilter a specific variable that I can designate. So, if container tab 2 is selected while 1 is on screen, the unfilter macro would run. Thank you and I look forward to your advice. Thanks!

Re: Clear Filter Macro Triggered by Container Tab Change - Please help

m_woolf — Thu, 11 Feb 2016 14:34:08 GMT

There is no event for clicking on a container tab (that I know of).

You might overlay a transparent button on the tabs, and use button actions to do the clear and activate the chart.

Re: Clear Filter Macro Triggered by Container Tab Change - Please help

Thu, 11 Feb 2016 16:23:42 GMT

Hi Mike,

Thanks for the help. I tried implementing some macros I found on the community through the button, but it would not work. Perhaps, I did not change a variable within that factor. I would appreciate your assistance on this. below is the macro I am using:

sub ResetContainerObject

ContTabSelect0("CT02")

end sub

sub ContTabSelect0(CT02)

set MV_ContainerObj = ActiveDocument.GetSheetObject(CT02)

Set MV_ContProp = MV_ContainerObj.GetProperties

MV_ActiveIndex2 = MV_ContProp.SingleObjectActiveIndex

MV_ActiveIndex2 = 0

MV_ContProp.SingleObjectActiveIndex = MV_ActiveIndex2

MV_ContainerObj.SetProperties MV_ContProp

End Sub

Thank you!