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.

[sunny_talwar]

Not able to replicate your issue. Check attached

[matthewp]

your example opens differently in mine

[sunny_talwar]

Must be a version issue I think. I am using QV12

[Anonymous]

Hi,

I get the same result as Sunny does.  What is the version of your QlikView client ?

[sasiparupudi1]

if you have only that expression in the straight table it should show the desired result. If you enabled the expression Versionnum - Above(Versionnum) you will see the above behaviour..

it is nothing to the qlikview version as I have QV11 on my pc

[matthewp]

I am using Version 12.0.20001.0 SR1 64-bit Edition (x64)

[matthewp]

I am using Version 12.0.20001.0 SR1 64-bit Edition (x64)

[sunny_talwar]

I think it would be good time to move away from QV12 SR1 because it has too many known bugs.

[Anonymous]

It's just a co-incidence, but I heard from our QlikView partner today that they advice not to move to QV12 SR1 yet  because of several known issues.  I suggest you downgrade and give it a try.