Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

wolfgangmohr
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.

NULLValues.jpg

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)

1 Solution

Accepted Solutions
Highlighted
anbu1984
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

View solution in original post

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
wolfgangmohr
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
anbu1984
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

View solution in original post

Highlighted
MVP
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
wolfgangmohr
New Contributor III

Re: Suppress NULL in a TabDiagr with Set Analysis

Hi Jonathan,

thanks your correct and helpful answer!
We do have only one possibility to check: correct,
and anbu was first:-)

Thanks to all of you!

Wolfgang