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: 
kmstephenson
Creator
Creator

Interpretation of Document Analyzer Results

Hi All,

To improve speed and performance, what should I focus on in the Document Analyzer? I'm using V2.8 on a large application - I'm pulling in QVDs and most of the calculations are done outside of QV. My dashboard is 60 sheets (!!) and appears to be the heaviest in the UI, not as much in the data model. I'm not sure what I should focus on in the Document Analyzer, and what I should be comparing RAM footprint, calc time, etc. to.... what is acceptable? What times do you all shoot for when the dashboard is opened or a selection is made? If the end users don't want to split up the application into multiple dashboards and document chain, what would you recommend as a work around to improve performance?

Thanks!!

Kristina

25 Replies
kmstephenson
Creator
Creator
Author

How is it that heavy sheets (more specifically sheets with objects with high calc time or memory) slow down a dashboard even if a user isn't ever navigating to that sheet? What else is going on in the background that would cause slowness when those heavy objects are in the dashboard if they aren't calculated until after the sheet is visible? Thanks for clarifying - trying to get a better grasp of what is calculated and when! When I checked the Objects tab of the Document Analyzer, the top 4 objects with the highest calc times are all from the same sheet header (I have sheets and subsheets). If a user never accessed the "Utilization Detail" sheet link that contains links to all of these charts, is this not slowing down the application at all?

Thank you!!

kmstephenson
Creator
Creator
Author

Thanks, I'll look into this!

mr_barriesmith
Partner - Creator
Partner - Creator

Hi

Has anyone else noticed the Database Tables in memory statistics now no longer has a Byte reading?

I used memory stats Byte readings to estimate State RAM against virtual database size - seemed reasonable in 11.2 and before.

Any ideas on how to estimate the RAM required for an App without saving it uncompressed?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Adam,

The memfile reporting 0 for Size and Bytes is a reported bug on QV12. It's still there as of SR4, but I hope its fixed in SR5.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

tellmalaika17
Contributor II
Contributor II

Hi Rob,

What is Expression Usage count in document analyzer??

I have an expression usage count as 42 for one straight table.  It shows that RGB(Grey) has been used 42 times.  I am not able to understand this.

Would appreciate you can explain this.

Thanks,

Malaika

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

" Expression Usage count" is how many times this specific expression is used in the application. For example, the expression "sum(SalesAmount)" may appear in a bar chart, a line chart and two straight tables. In that case the expression usage count would be 4.

Expressions are captured by DA wherever they are used. In the case of "RGB(Grey) ", it may have been used in a Background Color or some other color expression.  Select the expression on the Expressions sheet and then look at the "Expression Location" listbox to get an understanding of where it is used.

Of course, if the numbers you are seeing in DA don't make sense in your application, I'm always open to entertaining the idea of a bug in DA

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

tellmalaika17
Contributor II
Contributor II

Thanks for your prompt response.

I checked expression location it says 'TotalBgColor.ColorExpr'.  I do not understand where should I look up to get the location.

Plus in this case it is just one object ie straight table and RGB has been used just for that object. I do not understand how it is read as 42 usage counts.  Would be happy to get an answer for this..

Thanks,

Malaika

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

TotalBgColor.ColorExpr is total row on the Straight Table that has been formatted using "Custom Format Cell". Look at the Style tab in the Properties. Is the style "Custom"?  How many columns does the table have? Does the chart use Visual Cues?

-Rob

tellmalaika17
Contributor II
Contributor II

Yes you are right. I have used style 'light' and using custom format cell changed the colors. Alternate colors in the rows ie white and grey.

Straight table has 21 columns... No visual cues..

Thanks,

Malaika

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Makes sense. 21 columns * 2 alternate colors = 42 occurrences.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com