Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a straight table with two columns, a dimension and an expression.
Expression: =IF((Versionnum-Above(Versionnum) = 1) OR ([Versionname] = 'V100001'),NULL(),'Check')
What I want is to only output the rows that aren't NULL
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.
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
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.