Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

matthewp
Contributor III

Cant hide nulls in straight table

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.

16 Replies

Re: Cant hide nulls in straight table

Not able to replicate your issue. Check attached

Capture.PNG

matthewp
Contributor III

Re: Cant hide nulls in straight table

your example opens differently in mine

aaaa.PNG

Re: Cant hide nulls in straight table

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

filip_duchateau
Contributor II

Re: Cant hide nulls in straight table

Hi,

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

sasiparupudi1
Honored Contributor III

Re: Cant hide nulls in straight table

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

Re: Cant hide nulls in straight table

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

matthewp
Contributor III

Re: Cant hide nulls in straight table

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

Re: Cant hide nulls in straight table

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

filip_duchateau
Contributor II

Re: Cant hide nulls in straight table

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.

Community Browser