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]

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.

[Anonymous]

A Hidden Expression ?!?

How can i do that please ? 

[swuehl]

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.

[Anonymous]

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

[swuehl]

[Anonymous]

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

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]

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]

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.

[Anonymous]

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:

Thanks in advance for your help.

Sébastien.