topic Re: Container Object,Selected Index Change in QlikView

Container Object,Selected Index Change

AbhijitBansode — Tue, 21 Jun 2011 05:58:11 GMT

Hi All,

I want to enable or disable the button when index of container object change.

e.g. container object contains bar and pie charts , when pie chart is selected ,

button to change group bar chart into stack bar chart should be disable and vice versa.

i can enable or disable this button by checking currently active index of container obeject,

by using SingleObjectActiveIndex property. but i'm not getting where should i fire this trigger(macro).

Is there any event which can track when Index Of Container Object changes..

Please sugegst some ideas, how should i achieve the same?

Container Object,Selected Index Change

kaushiknsolanki — Tue, 21 Jun 2011 06:18:27 GMT

Hi,

You can use container properties to find the object id of the object it contains.

Go to API Guide(C:\Program files\Qlikview\Documentation) in your computer and visit Automation Example sheet.

class = IcontainerProperties and Member is Containedobject.

When you click on this you will find the example too.

Hope this will help you.

Regards,

Kaushik Solanki

Re: Container Object,Selected Index Change

AbhijitBansode — Tue, 21 Jun 2011 09:19:53 GMT

Kaushik, thank you for concern.

I think, I've nt explained my probem properly.

I'm able to get contained objects of Container,

below is my macro code and it is working properly:

Set ContainerObj= ActiveDocument.GetSheetObject("CT01") '

              set ContProp=ContainerObj.GetProperties
              'get index of currently active tab/object of container
              activeIndex= ContProp.SingleObjectActiveIndex

              'get the button object which is use to switch bar chart between group->stack and vice-versa
              set button =ActiveDocument.GetSheetObject("BU01")
              set prop = button.GetProperties

              if activeIndex=0 then                      'if Container displays Bar chart
                prop.EnableCondition.v = "1"
               else                                             'if container displays Pie chart
                 prop.EnableCondition.v = "0"
              end if

              button.SetProperties prop

              ContainerObj.SetProperties ContProp

this code do the work, but i'm not getting from where should i fire(trigger) trigger this macro.

I hope , this time i'm clear..

Container Object,Selected Index Change

kaushiknsolanki — Tue, 21 Jun 2011 09:32:11 GMT

Hi,

First thing place this code in between this two lines

sub your_macro_name

....code here

End sub

then,

All you have to do is create a button.

Go to properties of button -> Action Tab -> Click on Add Action -> Select External -> Select Macros -> Assign the macro name.

This will sove your problem.

Regards,

Kaushik Solanki

Re: Container Object,Selected Index Change

AbhijitBansode — Tue, 21 Jun 2011 10:05:44 GMT

Hi Kaushik,

I forget to include Sub and End Sub in above mentioned code.

but i've used it in my code.

I don't want to trigger this code on any button, when user changes object in the container object only then it should be fired.

please refer attached screen shot.

Re: Container Object,Selected Index Change

kaushiknsolanki — Tue, 21 Jun 2011 10:21:42 GMT

Hi,

Have a look at this example.

I have done something which you want but in different manner.

Hope this will help you.

Regards,

Kaushik Solanki

Re: Container Object,Selected Index Change

AbhijitBansode — Tue, 21 Jun 2011 11:55:04 GMT

Hi Kaushik,

gone throug your example , but this is not the one i really wanted.

also i didn't find any container object in it.

please refer the attached app.

hope u are aware of Container Object in QV10.

Re: Container Object,Selected Index Change

kaushiknsolanki — Tue, 21 Jun 2011 12:10:35 GMT

Hi,

Let me tell you what i undertood from your explaination.

You want to hide group button when you click on pie chat and you want it to be back when you click on barchart.

According to this i have sent you an example where i tried to do the same without container object.

The reason of not using container was you cant have any action on the objects placed in container.

Regards,

Kaushik Solanki

Re: Container Object,Selected Index Change

AbhijitBansode — Tue, 21 Jun 2011 12:37:00 GMT

Your understanding is totally correct Kaushik.

I know that Objects placed in Container do not have any action..

but accroding to my requirement, I have to Use Container object.

So need some workaround for this.

Anyone, any idea?

Re: Container Object,Selected Index Change

Wed, 22 Jun 2011 09:55:54 GMT

I am also interested in this behavior,

How to set trigger on tab selection of a container.

Abhijit, I could not reuse your macro code, as it fails with the following error message:

Object doesn't support this property or method: 'ContProp.SingleObjectActiveIndex'

I could not find this property as well from the API Guide.

Re: Container Object,Selected Index Change

AbhijitBansode — Thu, 23 Jun 2011 06:00:24 GMT

U might be missing something or else u might be providing wrong Object ID od container object.

because same works for me...

i'm still stuck at wher to fire this trigger..

Re: Container Object,Selected Index Change

Thu, 23 Jun 2011 09:38:07 GMT

I fired the trigger, with your macro code, on the trigger page of the sheet, there you can trigger a even on activating an object (CT01). This works fine!

But would be nice if Qlikview can make triggers on the object, tabs etc.

Container Object,Selected Index Change

AbhijitBansode — Thu, 23 Jun 2011 10:33:26 GMT

Thanks a lot Jochem..

It solved my problem...

Re: Container Object,Selected Index Change

Tue, 19 Jun 2012 11:24:39 GMT

Hi Jochem and Sparten,

I know it's been a while since you solved this issue, but we're facing the same one and have no clue on how to solve it. From my understanding, the activate sheet trigger only happens when the sheet is activated the first time, but once in the sheet, activating other objects doesn't trigger anything.

How do you manage to trigger every time a tab is selected? If you could provide an example it'd be very helpful. We're using QV11.

Thanks a lot.

Re: Container Object,Selected Index Change

Tue, 19 Jun 2012 11:28:54 GMT

you have to use the 'Sheet object event triggers' not the 'Sheet event triggers' these will be fired once.

Choose your CT object and use the macro code from spartan as an action.

Re: Container Object,Selected Index Change

Tue, 19 Jun 2012 11:54:01 GMT

Either I'm going nuts or there's no such option on QV11. I guess that those Object Event Triggers you're talking about were removed in version 11, as I read on this post http://community.qlik.com/thread/39913

Can you confirm which version are you using.

Thanks a lot for your time.

Re: Container Object,Selected Index Change

Tue, 19 Jun 2012 12:01:52 GMT

You are right, i have them both installed, in V10 this option was there, in V11 it's gone, so you're not going nuts!

Re: Container Object,Selected Index Change

murozel76 — Tue, 25 Sep 2012 07:29:36 GMT

I was also about to "go nuts" this! Thankfully, I have found this thread