topic Re: QVW opens too slow! in QlikView

QVW opens too slow!

azimabadi — Mon, 10 Sep 2012 09:25:50 GMT

I had a Document that worked good. but after i added a new Report, it takes really long time to open. It opens really slow from Accesspoint and too with Qlikview desktop.

Anybody has any idea how can i find the problem and solve it?

Best regards

Peyman

Re: QVW opens too slow!

SunilChauhan — Mon, 10 Sep 2012 09:36:28 GMT

try optimize your application using optimization techniques

use keep in place of join

combined the table if paoosible .it will reduce traverse time

use mapping load

Remove synthetic Key and Circular loops if any

hope this helps

Re: QVW opens too slow!

Anonymous — Mon, 10 Sep 2012 09:44:37 GMT

Also make sure you do not have any large tables open. When you open a .qvw file without any selections made,

any chart, table or other expression fully expanded ("open") will be calculated. That means all the expressions in the table will be calculated, so if the table contains a lot of data this might take some time especially if you have calculated dimensions or set analysis (amongst other things). If this is the case then minimize the objects or use calculated conditions for example do not show data until at least a certain period is selected or whatever you can base selection on in your application.

Re: QVW opens too slow!

azimabadi — Mon, 10 Sep 2012 09:54:03 GMT

Thank you Sunil and niromo,

you are right and all of this points are very important in performance. But my problem is that the Data Model is the same and i didn't change any thing in it or on interface (a new chart or maximizing a closed chart), but Document opens 5 time slower after i added a report to QVW.

Re: QVW opens too slow!

Anonymous — Mon, 10 Sep 2012 10:02:20 GMT

Just a check question, but are there any triggers in place for the document "on open"?

I would also check if the .qvw reloads faster if I remove the report, make a copy first

Re: QVW opens too slow!

azimabadi — Mon, 10 Sep 2012 10:37:42 GMT

my QVW is in customer site. But as i can remember there is no trigger on open. I will check it tomorow.

It's a good idea and i want to check the QVW without report tomorow.

Ofcurse my problem is not the reload, the opening time of documet is my problem.

Re: QVW opens too slow!

Anonymous — Mon, 10 Sep 2012 11:11:07 GMT

I mean open

Re: QVW opens too slow!

Mon, 10 Sep 2012 11:18:25 GMT

Hi,

if the charts all are minimized stage while opening the document then document will open fastly compare than before.

Regards,
Kabilan K.

Re: QVW opens too slow!

psankepalli — Wed, 15 Apr 2015 16:19:00 GMT

Hello Peyman,

Have you got any solution for your situation. I am facing the same problem to my QVW. its taking more time to open the document. Please Help!

Thanks

San

Re: QVW opens too slow!

psankepalli — Fri, 17 Jul 2015 15:41:55 GMT

Hello Payman,

I had the same problem in the past, I tried to optimize it, & did all the performace tuning and everything, but no luck. Then I had a backup qvw file before I add few tabs and one tab. I took that backup file and recreated the same tasks again. now its working fine. some time because of the memory issue or correpted charts Document will be opening very slow or opens very slow at access point. I would suggest you try to recreate the same chart on backup qvw file if you have any. This resolved my issue.

Hope this will help you!

Thanks

Re: QVW opens too slow!

Sat, 20 May 2017 22:35:53 GMT

Hi all,

I had the same problem, and finally I discovered that some hidden tabs I used to validate figures were causing this delay in opening because of some big tables loading a lot of information.

My solution was to delete those tabs from my document, and use a different document for validation.

Regards

EduardoG

Re: QVW opens too slow!

Sergey_Shuklin — Sun, 21 May 2017 05:42:00 GMT

Hello, Peyman!

If your project load time suddenly became huge, first of all you need to check your script for mistakes. Run it step by step, table by table and watch carefully for the file size and time load. May be some of your previous filters refuse to work (because some of field values has changed). Or may be some table is loading w/o a key and have an association with all data model tables. So, I recommend to start from the script. If it will not help, the next step will be - checking the formulas. Sometimes expression may crush and replace relative values on absolute (I've faced that case one time).

Re: QVW opens too slow!

Anonymous — Sun, 21 May 2017 09:20:10 GMT

try to save you document at at a sheet without any charts --> I call it a start page

--> even if you have on open triggers with call sheet actions

--> the actions/triggers are applied after opening

So I suspect you have saved your qvw when a sheet with some heavy calculations were opened...