topic Re: How to get a chart visible from a container in QlikView

How to get a chart visible from a container

Thu, 17 Jan 2013 11:59:53 GMT

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

Re: How to get a chart visible from a container

lironbaram — Thu, 17 Jan 2013 12:23:40 GMT

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

Re: How to get a chart visible from a container

Anonymous — Thu, 17 Jan 2013 13:17:44 GMT

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

Re: How to get a chart visible from a container

Thu, 17 Jan 2013 13:47:22 GMT

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

Re: How to get a chart visible from a container

Thu, 17 Jan 2013 13:52:44 GMT

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

Re: How to get a chart visible from a container

Anonymous — Thu, 17 Jan 2013 13:56:20 GMT

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

Try now

Re: How to get a chart visible from a container

Thu, 17 Jan 2013 14:07:45 GMT

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

I have 11.20 qlikview version

Regards

Giampiero

Re: How to get a chart visible from a container

Anonymous — Thu, 17 Jan 2013 14:13:17 GMT

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..

Re: How to get a chart visible from a container

Thu, 17 Jan 2013 14:32:35 GMT

I see.

Thank you for your help.

Regards

Giampiero