Cant hide nulls in straight table

[matthewp]

I have a straight table with two columns, a dimension and an expression.

Dimension: Versionname

Expression: =IF((Versionnum-Above(Versionnum) = 1) OR ([Versionname] = 'V100001'),NULL(),'Check')

Output

Versionname    Expression

V100001         

V100002         

V100003         

V100004         

V100007          Check

V100008         

V100009         

V100010         

V100011         

What I want is to only output the rows that aren't NULL

Expected output

Versionname    Expression

V100007          Check

I have ticked "Suppress when value is null" in the Dimensions tab.

I have ticked "Suppress zero-values" and Suppress missing" in the Presentation tab.

[matthewp]

That would make sense, as this was working before we upgarded

[matthewp]

What version do you recommend?

[sunny_talwar]

SR12 Seems to be a good version. Not sure about SR2 or SR3

[Anonymous]

I am working with QV11.20 SR12.  No problem so far.

[sunny_talwar]

Look here:

Left join broken in QlikView 12 SR1?

Left Join Not Working (Except First Row)

[matthewp]

Could this then be achieved using a conditional in the expression tab?

[#8]

Hi Matthew,

You could try checking to see if the value is null and only display it if is it NOT null.  For example:

if (not isNull(field), field)

The field will only be displayed if isNull() does not return true.

Hope that helps!