Qlikview slow to load due to Text Objects

[NewToQV]

Good afternoon,

I have a QV document which has LOTS (I mean lots) of text objects in which I am calling values from a straight table into. However the load time when I go to the tab containing these is very long. Is there anyway to speed up or optimize the load time for text objects?

[rwunderlich]

I've seen sheets with many hundreds of text objects  take a very long time to render, especially when most of them have calculations.  It's typically not a good design pattern. 

You said "calling values from a straight table". Do mean repeating some of the expressions that are used in a straight table?

Are you using many variables?  Is the page always slow when you return to it or just the first time?

-Rob

[jerrysvensson]

Less is more. 🙂

One thing you could try is to set the preload option on the application.  

[NewToQV]

Good morning,
So I have the following expression in my text boxes that is reading from a straight table. 

=Only(if([Partnership Product]='LS - DC' and [Minimum/Maximum]='Minimum',[Age]))

The partnership product value and age field name changes frequently.

I have about 1000 text objects. 

The request was to mirror the layout format that is shown in an excel file, however there the row heights, column widths etc. all vary. This is why I'm not just leaving in the straight table. The end use wanted to retain the easy way it was shown and laid out. In addition there are some pictures that are included in the objects. 

How can I maximize the load time? Or use the preload option? I'm very new to QV. 

[jerrysvensson]

Look for the preload option i QMC.

[rwunderlich · Accepted solution]

You are bound to have a challenge having that many objects on a single sheet.  I would suggest starting by improving the performance of the expressions, for example using set analysis instead of if:

Only({<[Partnership Product]={'LS - DC'}, [Minimum/Maximum]={'Minimum'}>} [Age])

You probably have a lot of expressions to look at 🙂

Even optimizing the expressions may not be enough.  There is a certain amount of overhead associated with each object and 1000 on a sheet is a lot!  I once worked on an application that had 1200 objects on a sheet. About 220 kpis in text objects.  The developer didn't like the way borders were rendered on text object so he added 4 line objects to each box.  Removing the 880 line objects (even though they had no calculation) greatly reduced the render time of the sheet. 

You may test the difference between presenting the data in fewer objects vs so many objects. 

BTW, my least successful and most expensive projects have been when I tried to make QV look like Excel.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[NewToQV]

Thank you @rwunderlich . I will work on replacing the if expressions with what you suggest. Can you advise how/what Qlikview is doing between both of the statements?

I'd love to simplify and reduce the number of objects. I just don't know of a way to visually show what the client wants without it. 

Removing Boarders for the text objects have helped load time quite a bit. 

As for the preload option, do you know where this might be? Everywhere I look it states to go to the performance tab but I can't seem to find it in the Document Properties. Even when I navigate to another tab and come back the load time is the same every time. Any other suggestions to quicken the load time? Note that load time in Chrome is exponentially faster than Internet Explorer. Thoughts to this as well?

[rwunderlich]

The expression I suggested is using Set Analysis https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctio....

Document Preload  an option in the server on the QlikView Management console. It causes the document to be loaded by the server immediately after reload. Preload does not do any document calculations so I don't think it will help you in this instance. I would not recommend it for this case. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[NewToQV]

Thank you @rwunderlich . Any other suggestions to assist in load times besides not using the darn text objects? If I click on another tab and return to the one containing everything, the load time is the almost the same as loading it for the first time. 

[rwunderlich]

If you go to another tab and return before making any selections (that is returning with the same selections in force), is it still slow ?

-Rob