Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 

Set Analysis vs Suppress Zero/Null

Can anyone advise whether it is more efficient to use an aggregation with set analysis (eg: Sum({$<Field={'value'}>} Count) or one with no set analysis (eg: Sum(Count) and a combination of "Suppress When Value is Null" on the Dimensions tab and "Suppress Zero-Values" on the Presentation tab?

In my use case both achieve the same result.  My thinking is that set analysis avoids doing unecessary aggregations that are then suppressed and so should be more efficient, but it depends on how smart QlikView is under the hood.



2 Replies

Interesting question. I have no idea. Perhaps hic can tell us the answer.

talk is cheap, supply exceeds demand

I haven't tested it, but I would guess that "Presentation -> Suppress Zero-values" is more efficient since it uses existing selection, whereas Set Analysis makes a new selection that needs to be evaluated.

The setting "Dimensions -> Suppress when value is NULL" only affects the dimension, and not the "Count" that you use in your aggregation.