topic Re: How to identify which Object ID is active inside a container in QlikView

How to identify which Object ID is active inside a container

Tue, 17 Apr 2012 15:17:19 GMT

I have a container with a number of charts displayed inside it. I would like to change the caption of the container depending on which chart is displayed.

If my charts had object ID's of CH01, CH02,CH03 CH04 is it posible to create a formula in the Caption of the container that does something like

If ObjectID=CH01 then "Title should be this"

I can't find a way to reference which is the active chart object inside the container.

How to identify which Object ID is active inside a container

ipauldur — Tue, 24 Apr 2012 02:33:10 GMT

Hi,

I want to know the active object inside the container. Did you get any idea on this?

If yes, please share to me.

Thanks & Regards,

Durai.

Re: How to identify which Object ID is active inside a container

Tue, 24 Apr 2012 08:44:59 GMT

Durai

I haven’t had any answers on this one yet and I haven’t been able to figure it out on my own. If I do manage to work it I’ll post the answer so you can see it.

Mark

Re: How to identify which Object ID is active inside a container

agigliotti — Tue, 28 May 2013 08:52:02 GMT

Hello,

I have the same needs, I'd like to show an input box only if a given object is activated inside the container.

Can anyone help me to achieve it?

Many thanks & Best Regards

Andrea

Re: How to identify which Object ID is active inside a container

flipside — Tue, 28 May 2013 09:10:29 GMT

Hi,

This can be done via macros ...

set CTObj = ActiveDocument.GetSheetObject("CT01")

set CTProp = CTObj.GetProperties

MsgBox CTProp.SingleObjectActiveIndex

... but you have to be careful. If you re-order the objects, it doesn't seem to return the correct index until you add a new object. (For QV11 SR2 at least).

flipside

Re: How to identify which Object ID is active inside a container

agigliotti — Tue, 28 May 2013 13:19:28 GMT

Thanks flipside, but the problem is how and when can I fire that macro ?

I'd like to enable conditional show on input box (outside the container) only if the container active object index is equal to 5.

Andrea

Re: How to identify which Object ID is active inside a container

flipside — Tue, 28 May 2013 14:08:42 GMT

I think I'd be tempted to just use conditional show objects with their individual visibility controlled by a list box (set to one selected value). So, in script, create a table such as ...

ListBox:

Load * inline [

2];

Then overlay each of your objects with conditional show as ID=0, ID=1 etc. You should be able to make this look a bit like a container except you wouldn't be able to minimize/maximize it and nothing can be Size to Data.

flipside

Re: How to identify which Object ID is active inside a container

agigliotti — Tue, 28 May 2013 14:37:52 GMT

ok this could be a workaround but I want to use the container object.

Regards

Andrea

Re: How to identify which Object ID is active inside a container

flipside — Tue, 28 May 2013 14:45:46 GMT

The macro code for setting the active object is ...

sub ContainerControl_btnSelect

set LB_ID = ActiveDocument.Fields("ID").GetPossibleValues

set btnObj = ActiveDocument.GetSheetObject("CT01")

set btnProp = btnObj.GetProperties

btnProp.SingleObjectActiveIndex = LB_ID.item(0).text

btnObj.SetProperties btnProp

end sub

(This will set to minimum or first selected value of ID).

Then use a listbox with ID as the field overlaying the container object list and have a field trigger. Again has limitations on maximise/minimize.

I think this is less robust than the other workaround because of the container index jumping around.

flipside

Re: How to identify which Object ID is active inside a container

agigliotti — Tue, 28 May 2013 14:54:10 GMT

If I well understood the user don't clic on the container object tab but selecting a value from the listbox that contains (0, 1, 2, etc...)

Is that correct ?

Also I noted it's only works with IEPlugin no AJAX and that's the problem !!!

Andrea

Re: How to identify which Object ID is active inside a container

flipside — Wed, 29 May 2013 08:17:51 GMT

Hi Andrea,

Yes, you will have to hide the container object list by placing a standard listbox over it (ensuring the listbox has a higher layer value than the container). It's a crude method but should work in plugin and AJAX. If AJAX is not working, make sure there are no MsgBox commands in your macro. Also there are some macro settings in QMC which might need adjusting - do you have other macros working in other documents?

The values in the "ID" field can be anything you want as long as they are unique, but if not using 0, 1, 2, 3 etc your macro code would need to translate the value to whatever index number the object is in the container.

flipside

Re: How to identify which Object ID is active inside a container

agigliotti — Wed, 29 May 2013 09:05:19 GMT

Hello,

I understood what you suggested me but when I show the container with the active object requested from listbox the user can see all other container objects and thus he may activate any of these.

Finally I should hide my inputbox (outside the container) but I can't because I can't catch this event.

The macro works well also in Ajax using Firefox browser, before I was using WebView in developer that doesn't works.

I hope will be a trigger with the container object in coming version.

Thank you for your interest.

Best regards

Andrea

Re: How to identify which Object ID is active inside a container

Mon, 13 Oct 2014 05:42:58 GMT

Hey,

I can use that hide container tab and instead of that listbox. but in my dashboard I need zoom in that. then it is not showing during zoom that chart.

So, is there any other solution other then listbox?

Thanks,