Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! 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

You can create a hidden expression t(labeled COND ) that checks that all expressions return something:

=Len(Trim( Only(FTE) )) AND Len(Trim( Only(Path) )) AND Len(Trim( Concat(Job) ))

adapt to your expressions used.

Then change all your existing expressions like

=If( "COND", YourCurrentExpression)

And enable 'suppress zero values' on presentation tab.

cocalero
Creator
Creator
Author

A Hidden Expression ?!?

How can i do that please ? 

swuehl
MVP
MVP

Basically create an expression on expression tab and set this expression column to hidden on presentation tab.

edit:

You can also do the same by repeating the conditional statement in each If() condition of each expression.

cocalero
Creator
Creator
Author

Sorry, but I do not see the option to hid the Expression 😕

swuehl
MVP
MVP

2016-06-16 18_57_16-Chart Properties [-].png

cocalero
Creator
Creator
Author

Ok, thanks for your help but do not see the Option:

Capture.PNG

Then, I write this for each Expression but it doesn't work:
If(Len(Trim( Only(Region) ))<>0,Region)

Do you have an idea please ?

swuehl
MVP
MVP

You don't see this option to hide the expression because you are using a pivot table chart, not a straight table chart.

But I think you should still be able to remove the lines where not all expressions return a value.

Could you post all your current expressions?

Or could you create a small sample QVW and upload this to the thread?

idogridish2
Creator II
Creator II

You can create a calculated dimension with an if statement that checks if all expressions returns a value,

and use the "suppress when value is null" on this field in dimensions tab.

how big is your model? and is it already slow? - you can try the solution and decide after.


best regards.


cocalero
Creator
Creator
Author

Ok, here my hidden expression:

"=Len(Trim(Only(Nom_DHACCOR))) <> 0 And Len(Trim(Only(Employee_CD))) <> 0 And Len(Trim(Only(Region))) <> 0 And Len(Trim(Only(Fte))) <> 0 and Len(Trim(Only(Path))) <> 0 and Len(Trim(Only(FTC_Nm))) <> 0"

And all my Expression here:

Capture.PNG

Thanks in advance for your help.

Sébastien.