topic Re: Dealing with null values in expressions in QlikView

Dealing with null values in expressions

nkosinde13 — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I want to show only values that have nulls on my straight table, how do I include this condition on an expression?

So e.g, in the example that I attached I want my table to return only Acc Num 223 and 200.

Thanks

Chanty4u — Tue, 07 Aug 2018 12:43:44 GMT

try caluclation dimension

If(Len(Trim([Field])) = 0, 'Null', Null())

sibin_jacob — Tue, 07 Aug 2018 13:08:10 GMT

you need to write your dimension as

If(Len(Trim(Ind)) = 0, [Acc Num])

Then check the suppress when value is null

Then add your expression

for example Sum(sales) or for testing add expression as 1

It will show values only for Acc Num 223 and 200.

nkosinde13 — Tue, 07 Aug 2018 13:26:05 GMT

Thank you all very much, it works perfectly 🙂

Chanty4u — Tue, 07 Aug 2018 13:27:59 GMT

Nice Please close the thread by making correct and helpful