# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

New Contributor III

## Suppress NULL in a TabDiagr with Set Analysis

Hi Folks,

I have a TabDiagr showing rows of Data where one Expression gives NULL.
These values should be suppressed as they are not relevant for the Analysis.

The first three are important, showing Minus values. Thereafter the NULL values should be suppressed.

The Expression for RohE is
sum ({\$<RohE={'>-2500<=-1'}>}RohE)

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Honored Contributor III

## Re: Suppress NULL in a TabDiagr with Set Analysis

You can add to this condition to all the expressions except first expression

If(Column(1) = 0, 0, Second_expr)

If(Column(1) = 0, 0, Third_expr)

Column(1) - Returns value of first expression

6 Replies
Highlighted
Not applicable

## Re: Suppress NULL in a TabDiagr with Set Analysis

You have values coming through from that first expression, so not sure I understand what you want to supress?

The Nulls within 'Rechnung', or the 0 Euro numbers from row 4 onwards?

Highlighted
New Contributor III

## Re: Suppress NULL in a TabDiagr with Set Analysis

Sorry Joe,

I want to suppress the lines with 0 Euro numbers from frow 4 onwards.

Tks

Wolfgang

Highlighted
Not applicable

## Re: Suppress NULL in a TabDiagr with Set Analysis

It looks like, 'Mitarbeiter', 'Rechnung' and 'Herkunft' are expressions also? Can you share those too please?

As they are returning values, that is why row 4+ are showing. So will need to adjust them to be relative to the first expression.

Highlighted
Honored Contributor III

## Re: Suppress NULL in a TabDiagr with Set Analysis

You can add to this condition to all the expressions except first expression

If(Column(1) = 0, 0, Second_expr)

If(Column(1) = 0, 0, Third_expr)

Column(1) - Returns value of first expression

Highlighted
MVP

## Re: Suppress NULL in a TabDiagr with Set Analysis

Hi

Expression for mitarbeiter:

If(Column(1) = 0, 0, <original expression for mitarbeiter>)

Replace the italics (including the <>) with the actual expression. Then do the same with rechnung and herkunft. Then enable suppress zero values.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
New Contributor III

Hi Jonathan,