topic Re: Opening the document too slow for a user in QlikView

Opening the document too slow for a user

ssanchez — Mon, 26 Jan 2026 18:19:17 GMT

Hi there:

I have a document published on the server using about ten users and has a slow but acceptable performance, the document allows server objects. Only one user has significant performance problems in opening the document (3 minutes). Can user objects affect performance at the opening of the document? How can we analyze what causes loss of performance?

Thanks in advance

Re: Opening the document too slow for a user

Mon, 08 Sep 2014 10:43:28 GMT

What version?

What client are they opening with?

Is the server located near or perhaps over seas?

Are you using IIS or QlikView Webserver?

Re: Re: Opening the document too slow for a user

ssanchez — Mon, 08 Sep 2014 11:04:57 GMT

Hi,

We use version 11.0.11440.0409.10 (details in attached file) with Qlikview Web Server and all users are located near, on the same LAN. All users use Ajax client (Chrome Browser).

Thank you.

Re: Opening the document too slow for a user

ashfaq_haseeb — Mon, 08 Sep 2014 11:11:07 GMT

Hi,

Can you try by deleting cookies, clearing cache.

Can you ask this user to access the same with some other PC.

Is the issue with user only, can you try to use some other ID with his machine.

did you add QlikView to trusted site.

Regards

ASHFAQ

Re: Opening the document too slow for a user

ssanchez — Mon, 08 Sep 2014 11:24:23 GMT

Thanks Ashfaq.

The problem occurs with this user access from other PC, deleting cookies or cache had no effect. The problem also occurs when you open the document using Qlikview Desktop with this user. Login with other users, you can open the document without problems on the same machine.

Best regards.

Re: Opening the document too slow for a user

ashfaq_haseeb — Mon, 08 Sep 2014 11:33:46 GMT

In this case I suggest you check server bookmarks under this users.

and if there are many try be deleting them.

Regards

ASHFAQ

Re: Opening the document too slow for a user

Mon, 08 Sep 2014 11:35:16 GMT

You can test and see if you disable server collaborated functions, if performance gets better

Re: Opening the document too slow for a user

ssanchez — Mon, 08 Sep 2014 11:59:29 GMT

Yes, disable the server collaborated functions improves performance. (Are the server objects calculated to login???)

I need to identify the object server causing performance loss because I can not delete all user objects. Is there any way to identify which user object has less performance?

Re: Opening the document too slow for a user

gandalfgray — Mon, 08 Sep 2014 12:08:29 GMT

When a specific user has problems opening a specific document it often helps if the user clicks "Remove last document state"

Re: Opening the document too slow for a user

shane_spencer — Mon, 08 Sep 2014 12:10:37 GMT

Have you considered setting the document to be Preloaded, so it's always available in Memory.

Re: Opening the document too slow for a user

Bill_Britt — Mon, 08 Sep 2014 12:22:29 GMT

HI,

I would look at upgrading to a more current release of Qlik.

Bill

Re: Opening the document too slow for a user

ssanchez — Mon, 08 Sep 2014 12:30:07 GMT

Thanks GandalfGray, we have already used that option but has no effect in this case.

Re: Opening the document too slow for a user

ssanchez — Mon, 08 Sep 2014 12:33:25 GMT

Thanks Shane, the document is already preloaded into memory. I think the problem is the number and the performance of the user objects.

Re: Opening the document too slow for a user

IAMDV — Mon, 08 Sep 2014 12:37:27 GMT

Hi Santiago,

Are there any "OnOpen" triggers/actions in the document? Also, I'd recommend having a simple landing page (Probably a textbox etc) instead of loading all the objects on the first screen. Also, go to "Sheet Properties" > "Objects" tab and check for "Calc Time".

Cheers,

www.QlikShare.com

Re: Opening the document too slow for a user

ssanchez — Mon, 08 Sep 2014 12:37:40 GMT

Thanks Bill, I'll remember. Unfortunately it is not possible at this time, too many documents in production. It should be the last option.

Re: Opening the document too slow for a user

gandalfgray — Mon, 08 Sep 2014 12:37:56 GMT

What if you have all charts etc minimized as default?

Re: Opening the document too slow for a user

miikkaqlick — Fri, 12 Sep 2014 12:55:19 GMT

Hi!

To my knowledge there isn't single tool that would give you bookmarks calculation time.

If that single user doesn't have too much server side objects, then you could do it by hand.

Br,

Miikka

Re: Re: Opening the document too slow for a user

Bill_Britt — Fri, 12 Sep 2014 13:06:53 GMT

Hi,

There are HTTP utilities out there that will show you load time of objects. You can even try the one built into IE.

http://msdn.microsoft.com/library/ie/bg182326(v=vs.85)

Look for "The Network tool (CTRL + 4)"

Bill

Re: Opening the document too slow for a user

ssanchez — Sun, 14 Sep 2014 09:09:55 GMT

Thanks to all for your answers. I solved the problem by removing the non-visible user-objects and optimized the visible user-objects manually, one by one. Hard work because the user had many items.

The problem was in the user objects (amount of objects and inefficient objects) but It's not easy to debug. and I have not found any official information on how user objects affect the performance of document Qlik.

Best regards