Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
cocalero
Creator
Creator

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.

cocalero
Creator
Creator
Author

I do not understand, i just see this now:

Capture.PNG

swuehl
MVP
MVP

You see this just doing the first step?

cocalero
Creator
Creator
Author

Yes 😕

cocalero
Creator
Creator
Author

Do you have an idea them ?

swuehl
MVP
MVP

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

cocalero
Creator
Creator
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'.

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