Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Performance optimisation

Hi,

Our QVW file size is vary huge.And giving slow response time.Is has having too many complex aggr functions on chart level as well.

I am sharing performance document analyzer file for our application  can you please suggest where should we go ahead to optimize the performances.

Thanks

12 Replies
Siva_Sankar
Master II
Master II

Hi,

From summary tab, it shows you have 127MB of unused fields in the dashboard. You can remove those. Find the below.

~

Click the Objects tab, and sort the calc time. You will come to know which object is consuming more calc time. Eg

From the above information, go to the object id CH30, pivot table and check the expressions.

Siva_Sankar
Master II
Master II

If you have many expressions, disable one by one and check which expression is consuming more calc time from the sheets tab, on the document properties.

Also refer https://community.qlik.com/blogs/qlikviewdesignblog/2013/01/28/memory-statistics

deepakqlikview_123
Specialist
Specialist
Author

Hi,

All those fields has been dropped already can you please tell me is there any difference between dropping fields and commenting out or removing the fields  the unused fields.

Thanks

Anonymous
Not applicable

There are fair few Calculated Dimensions.

You could maybe look at sorting them in the script.

Pivot table CH30 would be the first dashboard object I would look at.

Siva_Sankar
Master II
Master II

Deepak,

You can either comment or drop the unused fields. Make no difference.

deepakqlikview_123
Specialist
Specialist
Author

But after dropping fields also i do not know why fields  are showing as a unused fields in document analyzer and such kind of 127 fields are there.

Thanks

Anonymous
Not applicable

Do check if these fields are used in any expression variables as Document Analyzer only finds fields that are directly used in Dimensions or Expressions, and not fields indirectly used via expressions.

deepakqlikview_123
Specialist
Specialist
Author

Hi All,

I got below info can u please see is this really bug,