Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
arturomiquelveyrat
Partner - Contributor III
Partner - Contributor III

Set analysis: unexpected results when filtering on null field

Problem description

I'm trying to use Set Analysis to filter data. The expression is:

Sum({<Flag = {1}>} Amount)


If field Flag is not always null, the result is as expected: only records with Flag = 1 are included. However, if Flag is always null, all records are included.

Although it might not be a bug, I'm sure this is not what users expect of Set Analysis.

Examples


1. Flag not always null - Correct behaviour


Data and results:

FlagAmount
10
120
30

Correct.png

2. Flag is always null - Incorrect behaviour


Data and results:

FlagAmount
10
20
30

Incorrect.png

Labels (2)
0 Replies