Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
anitaberg
New Contributor III

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
Valued Contributor

Re: Are disabled expressions calculated?

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

View solution in original post

3 Replies
vishsaggi
Esteemed Contributor III

Re: Are disabled expressions calculated?

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

vamsee
Valued Contributor

Re: Are disabled expressions calculated?

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

View solution in original post

oknotsen
Honored Contributor III

Re: Are disabled expressions calculated?

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!