Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display only Rows with values on all Expressions

Hello,

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

Capture.PNG

How can i do that please ?

Thank you in advance for your help,

Sébastien.

19 Replies
swuehl
MVP
MVP

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
Not applicable
Author

I do not understand, i just see this now:

Capture.PNG

swuehl
MVP
MVP

You see this just doing the first step?

Anonymous
Not applicable
Author

Yes 😕

Anonymous
Not applicable
Author

Do you have an idea them ?

swuehl
MVP
MVP

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

Anonymous
Not applicable
Author

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

swuehl
MVP
MVP

That's the total line.

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

Anonymous
Not applicable
Author

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

Table Box values:

Capture.PNG

Straight Table Values:

Capture1.PNG

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

Do you have an idea ?

Sébastien.

swuehl
MVP
MVP

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