Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
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
MVP & Luminary
MVP & Luminary

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.