QVW opens too slow!

[azimabadi]

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

[#2]

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

[Sergey_Shuklin]

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).

[Anonymous]

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...