
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
When I remove the Set Analysis the table works as expected.
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.
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
