Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator 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
Highlighted

Not able to replicate your issue. Check attached

Capture.PNG

Highlighted
Creator III
Creator III

your example opens differently in mine

aaaa.PNG

Highlighted

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

Highlighted
Creator II
Creator II

Hi,

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

Highlighted
Master III
Master III

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

Highlighted
Creator III
Creator III

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

Highlighted
Creator III
Creator III

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

Highlighted

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

Highlighted
Creator II
Creator II

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.