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: 
Anonymous
Not applicable

Are disabled expressions calculated?

Hi!

BACKGROUND:

One client has a have a large straight table with around 500 000 rows and 51 columns.

It performs slow for both scrolling and when user clears all filters then that takes way too long time untill the table is refreshed with new records.

I have spent a lot of time now trying to test different performance best practice.

FINDINGS:

- Reducing the height of a large table improves scrolling performance. I reduced it to 14 rows, it performes better for scrolling.

- Removing one expression that was using if statement, improved the performance for clearing filter. After this was removed I could clear filters, with a reasonable wait time compared to when the if statement was there.

- I also found some hidden sheets in the document settings sheet overview

- No matter what tables in Qlik View does not seem to handle many columns very well, ie scolling performance is relatively slow even when selections are done (only 2500 records shown), just one simple calculation in a data model with optimal numeric keys

QUESTION:

There are some disabled expressions in straight tables that contains more if statements. I want to understand what they can potentially be used for, or if it is just poor clean up.

Does Qlik View calculate those disabled expressions, even though they are not shown in table?

1 Solution

Accepted Solutions
vamsee
Specialist
Specialist

No disabled or deleted expressions are not calculated.
Same goes with hidden or minimized charts.

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

Did you check the calc time in Sheet properties -> Objects tab -> Straight table ?

vamsee
Specialist
Specialist

No disabled or deleted expressions are not calculated.
Same goes with hidden or minimized charts.

oknotsen
Master III
Master III

Best practice:

Don't show half a million rows in a Straight Table.

Put a calculation condition on that thing, limiting that table to "what ever someone would actually use the table for". Based on what you are writing, that would be 2500 rows.

May you live in interesting times!