How to get a chart visible from a container

[#1]

Hi guys,

I'm trying to get visible or not a chart when I choose to see a chart in a container ?

Let me explain.

I have a container with two charts.

If I see the first chart nothing has to happen. If I choose the second chart in the container I'd like to get visible a chart (this chart is not in the container).

Is there possible?

Thanks in advance

Best regards

Giampiero

[lironbaram]

hi as far as i know selecting chart in the container is not an event that you can use as trigger

but you can put the two graphs you want to see together in a grid type container

then include this container in your main cinontaer attach is an example

[Anonymous]

Hey,

you can do that by using a macro.

The macro returns to a veraible the sirel number of curent object.

1. Replace the container number (CT01)

2. Create a  Variable named Container

3. Set the macro as an object triger In sheet prooerties under triggers, Sheet object event trigers, on active

sub Container

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

    set ContProp=ContainerObj.GetProperties       

    activeIndex= ContProp.SingleObjectActiveIndex

    set b = ActiveDocument.Variables("Container")

    b.SetContent activeIndex ,true

end sub

Works for me

[#4]

Hi Eran,

Thank you for reply.

I've just seen your qvw. May be I didn't understand but it seems it doesn't work.

I mean, if I choose one of the chart in the container I will expect to see appear a new chart but nothing happen.

Have I made something wrong?

Regards

Giampiero

[#5]

Hi liron,

I see.

Nice workaround. I have to understand if I can use it in my case.

Thank you so much.

Best regards

Giampiero

[Anonymous]

Look at the varieble in the text box, it changes when you choose one of the charts.

Try now

[#7]

I'm sorry, the variable doesn't change value.

I have 11.20 qlikview version

Regards

Giampiero

[Anonymous]

Your right!

It dosent work in version 11, i'm using ver 10 and it works find.

I canot find a way to set an object triger in ver 11..

[#9]

I see.

Thank you for your help.

Regards

Giampiero