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

Announcements
Join us in Bucharest on Sept 18th 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