Number of objects on a sheet

[Anonymous]

Hello,

Does the number of objects (e.g. charts) hidden or visible have impact on the performance. In other words is it better to distribute the objects over several sheets or can they all be placed on one sheet (some hidden, others visible).

Any thoughts?

Regards,

Rudi

[oknotsen · Accepted solution]

As long as an object is technically visible, it will be calculated so has impact on performance.

An object that is hidden behind another object is technically still visible, so will be calculated.

An object that is minimized will not be calculated (except for the caption bar if technically visible).

An object that is not visible as the result of a Conditional Show will not be calculated.

If it comes to designing a sheet (or a dashboard or whatever you call it), keep "Less is More" in mind. If you don't need it to answer the question that this sheet is supposed to answer, don't put it on it. More junk is only distracting (and bad for performance).

[Anonymous]

Thx Onno,

So what you're also saying is that an object on an inactive sheet is not caclulated and therefore it has no impact on performance. Am I correct?

[oknotsen]

If you are saying what I think you are saying, you are correct.

Simple example:

You have 24 sheets. Only the 1 sheet you currently have open will be calculated.

The objects on a different sheet will be calculated when you open it.

Qlik will only update the objects on the active sheet, so if you later move back to the sheet you opened initially, it has to calculate the objects that have changed.

[Anonymous]

Thx again Onno,

As we are discussing this. Is there a way to speed up the calculation on opening a QVW document or a sheet. I'm using a true star datamodel.

Cheers,

Rudi

[oknotsen]

Load the document after reload (option somewhere; don't have access to a QMC at the moment) could reduce the initial waiting time.

For large apps, look into "cache warming". This is the process in which you let some test script run right after reload which make a bunch of basic selections (or complex if you see that useful). This is more a general performance improvement then the specific question you asked, though if setup correct does do that.

If you are interested in a lot of theory about this topic (with some hands-on activities), ask your local Qlik office about the "Performance and Scalability" training. This is a 2 day training that covers a lot of the stuff you are having questions about .

[Anonymous]

Thx Onno. I will certainly look into that training.

Regards,

Rudi