Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III

Set Analysis Hides Row when Sum is Null/0

Hello Folks,

TL;DR Why does the Set Analysis filter out rows that don't match the filter, yet still show a "0" in table? 

I've got a QS table with one measure.  When there are no detail rows in the detail table that match the set analysis filter, the row is nulled out i.e,

Bad.png

 

When I remove the Set Analysis the table works as expected.

Good.png

The Set Analysis statement is relatively pedestrian.

SUM({<[Invoice Detail Charge Type]={'TOTPCS'}>} [Invoice Detail Quantity])

 

I've also looked at the "Include Zero Values" checkbox, and it seems okay.

IncludeZeroValues.png

 

Why does the Set Analysis filter out rows that don't match the filter, yet still show a "0" in table?  I'm on version QS Nov 2018 if that helps.

 

Any help is greatly appreciated.

1 Reply
sasiparupudi1
Master III
Master III

Add 

[Invoice Detail Charge Type]

into your table and see if it displays  the value 'TOPIC' in it.. If not, then you do not have data for the filter and hence, the row is blanked out