topic Select Tab in the Container using Macro in QlikView

Select Tab in the Container using Macro

Fri, 11 Feb 2011 16:05:05 GMT

Hi, All!

I have a Container with two tabs (two different tables inside). How could I using macro select one tab or another (accordingly user will see one table or another)?

Thanks.

Select Tab in the Container using Macro

Mon, 14 Feb 2011 17:31:35 GMT

Select Tab in the Container using Macro

maneshkhottcpl — Tue, 15 Feb 2011 03:31:51 GMT

Hi,

As per my understanding u need to display the tables(Charts) as per buttons click or sheet activate using some buttons.

I m sending the solution for the both please refer the attached qve application. and revert me back for any clarifications.

Thanks

Manesh

Select Tab in the Container using Macro

Tue, 15 Feb 2011 13:03:56 GMT

Hi, Manesh

Thanks. But I want that these tables are placed in the Container (please, see attach). If we click of first button - first tab will be displayed, second button - second tab will be displayed. Could you advice?

Thanks.

Select Tab in the Container using Macro

maneshkhottcpl — Wed, 16 Feb 2011 07:47:42 GMT

Hi,

Please refer the attached application.

Sheet1 --Press -- Display Sheet1

Sheet2--Press - Display sheet2

Revert for issue.

Select Tab in the Container using Macro

Thu, 17 Feb 2011 12:21:16 GMT

Manesh, I should use Container. Where is Container in your example?

Re: Select Tab in the Container using Macro

Fri, 20 Jan 2012 14:49:16 GMT

Hi Maxim,

I haven't tried this yet, but API 11 has this example

Set ContainerObj = ActiveDocument.GetSheetObject("CT01")

set ContProp=ContainerObj.GetProperties

ActiveObject=ContProp.SingleObjectActiveIndex

msgbox("Active Object=" & ActiveObject & " Id=" & ContProp.ContainedObjects.Item(ActiveObject).Id)

and property SingleObjectActiveIndex is described as read-write.

So you may try to assign to this property Id of one or another container object.

Re: Select Tab in the Container using Macro

Fri, 10 Aug 2012 10:17:49 GMT

Did anyone get this working please?

I need to activate an object within a container via a button.

Re: Select Tab in the Container using Macro

murozel76 — Tue, 25 Sep 2012 08:20:03 GMT

I have just tried a solution for the very same purpose and it has worked properly. Please find the sample code below. You can write as many copies of the same subprocedure as you need, by changing the name of the sub and the value of the MV_ActiveIndex variable so that you can attach each sub to a button, enabling your macros to be run when clicked on the relevant buttons.

Hope this helps.

Regards,

sub ContTabSelect0

set MV_ContainerObj = ActiveDocument.GetSheetObject("CT13")
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

Re: Select Tab in the Container using Macro

Anonymous — Wed, 24 Oct 2012 20:13:02 GMT

Did you ever get this to work on a button?

Re: Select Tab in the Container using Macro

murozel76 — Tue, 30 Oct 2012 07:09:22 GMT

Yes, I have a number of buttons each for activating a spesific tab in a container.

Just in the "actions" section of the button properties, I selected "run macro" and specified the macro name there.

Regards,

Re: Select Tab in the Container using Macro

Tue, 26 Mar 2013 17:12:20 GMT

Add a Button to trigger the Macro.

First you have to Set Variable to pass to the macro as it is not allowed to pass variables in the macro call. (vMCont and vMTab)

vMCont = container Object ID

vMTab = See Container - General - Label for Selected Item

Run macro = SetTabInContainer

Paste following code in to the macro editor

Sub SetTabInContainer

Set Container = ActiveDocument.Variables("vMCont")
Set Tab = ActiveDocument.Variables("vMTab")
Call InteranlSetTabInContainer(Container.GetContent.string,Tab.GetContent.string)

end sub

Sub InteranlSetTabInContainer (Container, Cname)

NewIndex = 0

Set ContainerObj = ActiveDocument.GetSheetObject(Container)
set ContProp=ContainerObj.GetProperties

for i = 0 to ContProp.ContainedObjects.Count - 1

if ContProp.ContainedObjects.Item(i).Text.v = Cname then
NewIndex = i
End IF

next

ContProp.SingleObjectActiveIndex = NewIndex
ContainerObj.SetProperties ContProp

end Sub

Re: Select Tab in the Container using Macro

StevenJDH — Fri, 31 May 2019 08:13:25 GMT

This was an issue that I brought up to R&D a while ago. Those who are using certain versions QlikView will notice that these properties no longer produce the desired result. The API for getting the active object and changing the active object programmatically can be found in this article with examples: https://support.qlik.com/articles/000070090