Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nkosinde13
New Contributor III

Dealing with null values in expressions

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

4 Replies
Chanty4u
Esteemed Contributor III

Re: Dealing with null values in expressions

try caluclation dimension

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

Highlighted
sibin_jacob
Contributor III

Re: Dealing with null values in expressions

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
New Contributor III

Re: Dealing with null values in expressions

Thank you all very much, it works perfectly 🙂

Chanty4u
Esteemed Contributor III

Re: Dealing with null values in expressions

Nice Please close the thread by making correct and helpful