topic Re: Set analysis exclude (but keep null() ) in QlikView

Set analysis exclude (but keep null() )

Anonymous — Wed, 15 Apr 2015 15:12:47 GMT

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

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

giakoum — Wed, 15 Apr 2015 15:18:03 GMT

robert_mika — Wed, 15 Apr 2015 15:21:04 GMT

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

Anonymous — Wed, 15 Apr 2015 15:38:49 GMT

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

Anonymous — Wed, 15 Apr 2015 15:40:04 GMT

Thanks for this answer also.