Display only Rows with values on all Expressions

[Anonymous]

Hello,

I would like to display only rows into the Straight Table where Values are presents in all Expressions:

How can i do that please ?

Thank you in advance for your help,

Sébastien.

[swuehl]

As first step, unhide this new expression and check that it shows -1 on all lines where each original expression shows a value and 0 if at least one original expression does not show a value.

If this is successful, label this expression COND,

Then e.g. for your first original expression, write:

=If( "COND", Only(Nom_DHACCOR))

For the second:

=If("COND", Only(Employee_CD) )

etc.

Now you should only see the lines with COND =-1, if 'suppress zero values' is enabled on presentation tab.

Now hide the expression column COND on presentation tab.

[Anonymous]

I do not understand, i just see this now:

[swuehl]

You see this just doing the first step?

[Anonymous]

Yes 😕

[Anonymous]

Do you have an idea them ?

[swuehl]

Seems to work for me,have a look at this demo

[Anonymous]

Than you a lot, but how can i suppress the first row where there are only '-' values please ?

[swuehl]

That's the total line.

Go to expression tab and select 'No totals' for each expression in option section 'Total mode'.

[Anonymous]

Then i have a problem i do not have the same result than my Table box:

Table Box values:

Straight Table Values:

the the lines with the same Matricule dissapear in the straight table.

Do you have an idea ?

Sébastien.

[swuehl]

If you want to see two lines for the same Matricule, you would need to add a dimension to group your data into a finer granularity, e.g.using FTE (two distince values per GL001348465 Matricule).