Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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.

Thx

Robin

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand
Highlighted

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.

HIC