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,
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.
Basically create an expression on expression tab and set this expression column to hidden on presentation tab.
You can also do the same by repeating the conditional statement in each If() condition of each expression.
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 ?
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?
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.
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.