Set analysis exclude (but keep null() )

[Anonymous]

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	_Field1	Amount
Sales	1	10
Sales		20
Sales	1	30
Sales		40
Sales	1	50

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

[giakoum · Accepted solution]

Ask null value in Set Analysis | QlikView Help, Tips & Hints

[robert_mika]

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

[Anonymous]

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

[Anonymous]

Thanks for this answer also.