topic Re: How to include only null values in an Expression in QlikView

How to include only null values in an Expression

sriddell — Tue, 21 Jun 2022 14:58:46 GMT

Hi,

I'm looking for help with an expression in a straight table.

I have a field called 'fordel' where some returns are = 1 and others are null. I then have a field which I wish to sum the values of, and that field is called 'enrol'.

I wish to display results only where fordel is not equal to 1, i.e. the null values. I've tried the below without success - I'd appreciate any advice.

sum({$<fordel-={'1'}>},(enrol)

Best wishes.

Re: How to include only null values in an Expression

maxgro — Tue, 21 Jun 2022 17:59:30 GMT

maybe

Sum({$-<[fordel={'*'}>} enrol)

or you can replace the null in fordel field with 0 in the load script and then

sum({$<fordel={0}>} enrol)

Re: How to include only null values in an Expression

sriddell — Tue, 21 Jun 2022 21:24:40 GMT

Thank you very much, Maxgro - the first solution worked perfectly (and I can understand why the second one would too). I really appreciate your advice here.