Not show Null values in expression

[#1]

Hej

In dimensions we have the "Don't show if value is Null" checkbox.

I would like to do the same with an expression.

I tried to use the expression as a condition for a dimension. But the expression contains elements that are not allowed in a calculated dimension.

Any way to work around this?

(The expression: = If(StatusTop = 'In process',If(min({$<Sector = {'2100'}>} Status) < '90',If(JobType='SubframeSet' and WeekPlannedFinish<=WeekNextWeek,WeekPlannedFinish)))

)

BR

/Mats

[bbi_mba_76]

Hi,

what about the suppress zero values and missing values flags in the presentation tab?

[#3]

Thanks for the reply.

I tried that now but it doesn't affect this column.

[jonathandienst]

Hi

The suppress zero-values only suppresses the row if all expressions return zero or null. Do you have multiple expressions?

Regards

Jonathan

[#5]

16...

[jonathandienst]

If any one of those expressions return something other than a null or a zero, then the row will not be suppressed.If you would like to suppress the row if one expression is null, then update all the expressions as follows (assuming for sake of example that the expression of interest is in column 4 of the row):

     Col1:  If(Column(4) = 0, 0, <expression for column 1 here>)

     Col2:  If(Column(4) = 0, 0, <expression for column 2 here>)

     ..

     Col4: <expression for column 4 here>

     ...

     Coln:  If(Column(4) = 0, 0, <expression for column n here>)

To detect nulls, use If(IsNull(Column(4)), .... or If(Len(Column(4) = 0, ....

HTH

Jonathan

[#7]

Interesting suggestions.

Testing right now.

Thanks

[#8]

I have one dimension (calculated)

Tried If(IsNull(Column(17))=-1,'',[Calculated dimension])

But all rows goes away

Will keep trying

[bbi_mba_76]

If(not(IsNull(Column(17))),[Calculated dimension])

or

f(len(Column(17))>0,[Calculated dimension]))

[#10]

I resorted to repeating the expression in all the other expressions and suppress null-values in the Presentation tab.

Took care of the problem.

Thanks everyone!