Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Not able to replicate your issue. Check attached
your example opens differently in mine
Must be a version issue I think. I am using QV12
Hi,
I get the same result as Sunny does. What is the version of your QlikView client ?
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
I am using Version 12.0.20001.0 SR1 64-bit Edition (x64)
I am using Version 12.0.20001.0 SR1 64-bit Edition (x64)
I think it would be good time to move away from QV12 SR1 because it has too many known bugs.
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.