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.
That would make sense, as this was working before we upgarded
What version do you recommend?
SR12 Seems to be a good version. Not sure about SR2 or SR3
I am working with QV11.20 SR12. No problem so far.
Could this then be achieved using a conditional in the expression tab?
Hi Matthew,
You could try checking to see if the value is null and only display it if is it NOT null. For example:
if (not isNull(field), field)
The field will only be displayed if isNull() does not return true.
Hope that helps!