Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
wolfgangmohr
New Contributor II

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

6 Replies
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?

wolfgangmohr
New Contributor II

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

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.

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

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
wolfgangmohr
New Contributor II

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

Community Browser