How to show charts in report even it is hidden in a container

[#1]

Hi All,

I have three charts that is stored in the same container and I need to show all in the same report at the same time.

Do you know how to do it?

# Top 10 Routes

# of Passengers

# Of Flights

I want them to be displayed in the report at the same time. Can anyone share me some idea?

Attached is the QVW application

User ID: Admin Password: admin123

Thanks in advance!

[robert_mika]

Properties--->Presentation--> Container Type-->Change to Grid

[Gysbert_Wassenaar]

Why do you want to use a container? If you want to show the charts at the same time, why not simply move them from the container to the sheet and delete the container?

[#4]

Hi Gysbert and Robert,

It is because of limitation on the screen size, I cannot show all charts at the same time. However, when it come to a print out, I want all of them to be shown on the same pieces of paper.

Just before I respond to this blog, I cloned the three charts into a hidden sheet and use that the charts from the hidden sheet instead as a work around solution.

However, it appears very ignoring as this means when I need to change properties for the chart in the container I will also have to change properties for chart in the hidden sheet. So I don't know if there is any better way to do it.

Elim.

[#5]

When I say hide the sheet, I simply put an always false criteria (e.g. 1 =2) into the show condition of the sheet new sheet object.

[stigchel]

Unfortunately your workaround is necessary for the standard report functionality in QlikView. For changing chart properties only once, have a look at linked objects:

QlikTip #26: Introducing Linked Objects in QlikView 10

[#7]

Hi Piet,

I tried link object before, but it appears doesn't work for me. If the inactive in the container, the report failed to populate the chart. I don't know is it because both charts shared the same status.

Elim.

[stigchel]

Hi Elim,

Yes, that's probably it. In that case you will need to duplicate the objects and unfortunately do changes twice...

Or maybe as another work around, instead of the container use button\text objects with an action to activate the relevant object. Overlay the objects (same size) in the 'normal' layering mode, the activation trigger will pull the chart on the foreground hiding the other objects. At least that worked for me on desktop, have not tried that online.

[jyothish8807]

Hi Elim,

Try like this:

Select 1st chart in the container, then open the report --> drag and drop the chart--> then close the report.

Select the 2nd chart from the container --> open the report again and now drag and drop the second chart in to the report.

Hope this works.

Br,

KC

[rwunderlich]

Linked Objects should work in this case. Just make sure you drag the cloned object from the reports sheet into the report, not the container copy.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com