Qlikview Containers

[thakkarrahul01]

Hello everyone,

Does QlikView load all charts inside container or only the one which is selected on sheet load?

[vardhancse]

Hi

While reloading the data only all the objects data will be loaded..only thing is whenever we open will see the data.

[thakkarrahul01]

You mean when we go on sheet where there is a container with 3 charts, qlikview loads all 3 charts and display the one we are on.

Am I understanding your response correctly?

[vardhancse]

At the time of dashboard reloading only data will be calculated &  loaded in all the charts.

Not like when ever we open the object it will reload/calculate and show the data

[gautik92]

yea yu r right

it loads all the the three chats and it will display one

[rwunderlich · Accepted solution]

All charts in the container will be calculated, not just the visible chart.

This can be a performance disadvantage (or advantage) over minimized or hidden charts, which are not calculated.

-Rob

[Anonymous]

I use containers quite frequently.  In one of my containers, I have a chart that can take 30 seconds or longer to render.  So, to avoid bogging down the normal container load when the sheet is selected, I require the user to trigger a variable with a button object on the sheet to only render that resource intensive chart when it is requested. I use a calculation error message to tell the user they must select a date range button to render the chart.

 

Let me know if you would like to learn more about this.

[thakkarrahul01]

Thank you mike for the alternative. Yes I would definitely like to know more about it.

Specifically, how you write calculated condition for keeping chart inactive until user have selected the option.

[Anonymous]

Okay, step one, you open up your chart properties and on the general tab, you add this calculation condition. Just replace your field to filter with what I have in brown here.  The chart will not render unless you have at least 1 value selected.  Instead of using a button, you could just use a list box with values.

To get an error message, I just used the Default and then typed what I wanted to appear in  the custom message windows.  I have not played with the other choices, but there is probably one that is more specific to a failed calculation.  The default met my criteria

So, the bottom line is the chart does not render until you have selected at least 1 value from any of your selected fields.  I used a variable for mine.  I would pick one of the dimensions you are using in your chart and use that as the criteria.

Hope that helps!

[Anonymous]

PS.  It would be nice if Qlik gave you the ability to use triggers as you moved through tabs on a container.  Or if a tab on a container had a reference name that indicated when it was the active one.  Than a trigger could be assigned and the charts would only render when selected.