Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I should optionally hide rows that have zero value in one expression.
Dim1 | Expr1 | Expr2 |
a | 100 | 1000 |
b | 200 | 2000 |
c | 300 | 0 |
d | 400 | 3000 |
e | 500 | 0 |
f | 600 | 0 |
By a button I wish to hide rows c,e,f, even if Expr2 has values that are not zero.
I don't want to add 'searchable' in 'presentation tab'.
Thanks!!!!
I found the solution.
In loading I pre-calculate my results also by joining more tables.
If the result value is zero (even if other fields are not zero) I put variable 'vZeroValue'=0 otherwise is 1.
In UI I put a button Show/Hide zero value that select 0 or 1 from hidden field vZeroValue.
You mean even if Exp1 (not Exp2) has value? Try using a button to set a variable 0 or 1 and use this for your 1st expression:
If(vVar = 1, Expression,
If(Expression2Label > 0, Expression))
Expression is a placeholder here and needs to be replaced by your actual expression1
PFA
Hy Sunny!
I have to put every value (I have lots of expressions, not only 2) like (false) zero and then in my table I have to check 'SUPPRESS ZERO-VALUE'? thanks!
You are right. There might be another way using a calculated dimension, but will have to look at your application before I can recommend the alternative
Hi Sunny! I think it is not possible in my case.... the value zero that leads hiding all the rows is calculated by other measures, then I think it is recursive. thanks!
I found the solution.
In loading I pre-calculate my results also by joining more tables.
If the result value is zero (even if other fields are not zero) I put variable 'vZeroValue'=0 otherwise is 1.
In UI I put a button Show/Hide zero value that select 0 or 1 from hidden field vZeroValue.