topic Not show Null values in expression in QlikView

Not show Null values in expression

Thu, 14 Nov 2013 08:56:27 GMT

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)))

)

/Mats

Re: Not show Null values in expression

bbi_mba_76 — Thu, 14 Nov 2013 08:59:17 GMT

Hi,

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

Re: Not show Null values in expression

Thu, 14 Nov 2013 09:05:26 GMT

Thanks for the reply.

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

Re: Not show Null values in expression

jonathandienst — Thu, 14 Nov 2013 09:10:13 GMT

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

Regards

Jonathan

Re: Not show Null values in expression

Thu, 14 Nov 2013 09:12:36 GMT

16...

Re: Not show Null values in expression

jonathandienst — Thu, 14 Nov 2013 09:27:44 GMT

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

Re: Not show Null values in expression

Thu, 14 Nov 2013 10:51:48 GMT

Interesting suggestions.

Testing right now.

Thanks

Re: Not show Null values in expression

Thu, 14 Nov 2013 10:59:01 GMT

I have one dimension (calculated)

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

But all rows goes away

Will keep trying

Re: Not show Null values in expression

bbi_mba_76 — Thu, 14 Nov 2013 11:01:29 GMT

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

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

Re: Not show Null values in expression

Thu, 14 Nov 2013 12:17:26 GMT

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!