Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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
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.
Deepak,
You can either comment or drop the unused fields. Make no difference.
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
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.
Hi All,
I got below info can u please see is this really bug,