Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
A Hidden Expression ?!?
How can i do that please ?
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.
Sorry, but I do not see the option to hid the 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.
best regards.
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.