Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
johflo
Contributor III
Contributor III

Set analysis exclude (but keep null() )

Hello, I've got a field (let´s call it _Field1) that only contains the value '1' for some of the records in the table.

I would like to create a set expression where I get the sum of all records with null() in _Field1.

Does anyone have a solution? I tried

Sum({$< _Field1-= {1} >} Amount)

but that doesn´t seem to work as long as _Field1 only contains null() for the rest of the records.

The table lookes something like this

Dimension1_Field1Amount
Sales110
Sales20
Sales130
Sales40
Sales150

I wan´t the sum of Sales to be 60   (20+40)

1 Solution

Accepted Solutions
4 Replies
robert_mika

Sum({1-< _Field1= {'*'} >} Amount )

15-Apr-15 4-20-36 PM.jpg

johflo
Contributor III
Contributor III

Great, thanks. I actually need some other statements in the set expression as well, so this was great.

johflo
Contributor III
Contributor III

Thanks for this answer also.