topic Re: Problem with container object in QV10 in QlikView

Problem with container object in QV10

AbhijitBansode — Mon, 30 May 2011 13:03:00 GMT

Need to change active object in the container by using macro.
There are four charts in the container object viz.,Yearly,Half-Yearly,Quarterly,Monthly.

Time Format,selection list box contains Yearly,Half-Yearly,Quarterly,Monthly as possible values.
depending upon selection in the list box, active object of the container should change.

I've gone through the APIGuide app for the same and found the below code:

Set ContainerObj = ActiveDocument.GetSheetObject("CT01")
 set ContProp=ContainerObj.GetProperties 
 ActiveObject=ContProp.SingleObjectActiveIndex

ActiveObject is giving the index of currently active object in the container.
I can also assign value to this property Like,

ContProp.SingleObjectActiveIndex=0 i.e. 1st object should get active.

but this script does not server the purpose.

need urgent help on this.

Problem with container object in QV10

stephencredmond — Wed, 01 Jun 2011 09:37:55 GMT

Hi,

That should work, but once you have made changes to the properties, you need to called the SetProperties function to apply them to the object:

Set ContainerObj = ActiveDocument.GetSheetObject("CT01") set ContProp=ContainerObj.GetProperties ActiveObject=ContProp.SingleObjectActiveIndex

ContainerObj.SetProperties ContProp

Regards,

Stephen

Problem with container object in QV10

stephencredmond — Wed, 01 Jun 2011 09:39:53 GMT

Sorry,

Should be something like:

Set ContainerObj = ActiveDocument.GetSheetObject("CT01") set ContProp=ContainerObj.GetProperties ContProp.SingleObjectActiveIndex = vNewTab

ContainerObj.SetProperties ContProp

The SingleObjectActiveIndex is a zero based index of the tabs in the container.

Stephen

Problem with container object in QV10

AbhijitBansode — Sat, 04 Jun 2011 11:20:37 GMT

thanks stephen,

i's missing to call SetProperties at last on Container object.

Now my problem is solved.

Problem with container object in QV10

ramonarcusa36 — Thu, 28 Jul 2011 08:01:47 GMT

Hi you all.

I need to do something similar... but it looks like my Qlikview version (10.00.8815.6 SR1) does not support the SingleObjectActiveIndex property. I just copied Stephen Redmond's code, which looks perfect, but it gets stuck at that line, saying that object does not support this property or method.

Am I doing anything wrong or it's just about my version? Which version do you guys use?

Thanks!!

Re: Problem with container object in QV10

AbhijitBansode — Fri, 29 Jul 2011 09:16:46 GMT

yes , qlikview version might be the problem.

I'm using QV10 SR2.

I'm also not sure Whether QV10 SR1 supports this property.

Problem with container object in QV10

Tue, 10 Jan 2012 22:46:11 GMT

I couldn't get this macro to work in QV 10 ... now I'm on QV 11. I'm not sure what's wrong. Could you post a small QV 11 app with your macro? Thanks. I would greatly appreciate it.

Re: Problem with container object in QV10

Tue, 04 Sep 2012 13:14:07 GMT

Hi,

I got this macro syntax from somewhere else in the community, and it works fine as a macro.

Now my question is how can you cause this macro to run, whenever I choose a different container tab, so I can grab it's index ?

Any idea ?

Thanks,

Yigal

Re: Problem with container object in QV10

AbhijitBansode — Wed, 05 Sep 2012 03:21:26 GMT

Go to sheet properties -> Triggers(Tab) -> Sheet Object Event Triggers -> Select ObjectID of container object -> and run the macro u have on "On Activate" Event of the selected container object.

Hope this helps..

Thanks,

Spartan

Re: Problem with container object in QV10

Wed, 05 Sep 2012 14:28:12 GMT

Hi,

This is almost the correct answer...

This works whenever the container object is activated.

But what I need is to let the macro run, every time I press a different tab in the container.

Anyway, thanks for the prompt response.

Yigal

Re: Problem with container object in QV10

AbhijitBansode — Wed, 05 Sep 2012 18:18:51 GMT

I also had the same requirement ..

I did lot r&d, but did not found any property which gives me currently "clicked" tab of the container object..

hence settled down with above approach...

but it fulfils my requirement..

if u get any workaround.. pls let me know..

Regards,

Sparten

Re: Problem with container object in QV10

Thu, 06 Sep 2012 06:30:00 GMT

Hi,

Of course, I'll let you know/

Listen, I tried to "cheat" QV:

I removed one of the objects (say ListBox) from the container, and placed it in the same tab sheet the container is. Then I chose settings->sheet properties->objects->selected the List Box outside the container. There I noticed that this object inherited the trigger that I already assigned to the container. In the end, I returned this LB to the container - but still it does'nt work.

I believe they will fix it in one of the next SRs.

I'm trying to find a way to report this bug to them.

Regards,

Yigal

Re: Problem with container object in QV10

giakoum — Thu, 27 Sep 2012 12:31:37 GMT

sheet properties -> Triggers(Tab) -> Sheet Object Event Triggers

Where is that? I only have Sheet Event Triggers

Re: Problem with container object in QV10

Thu, 27 Sep 2012 13:01:21 GMT

Hi,

In QV11 - select a sheet which contains a container object, then sheet->properties->objects(select the container object)->triggers...

But still the trigger works only when the container is activated, not when you select a tab in the container.

Re: Problem with container object in QV10

giakoum — Fri, 28 Sep 2012 06:55:30 GMT

I still only see sheet triggers, not object...

Re: Problem with container object in QV10

Fri, 28 Sep 2012 15:01:23 GMT

Right, although u can select an object, the trigger stil belongs to the sheet. Thats the problem.

Yigal Douchan

Re: Problem with container object in QV10

Mon, 05 Nov 2012 12:57:37 GMT

Try moving to QV SR2, which has just been released.