Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys
i try to show specific values of field "EXPR3" on chart but it doesn't work
i write" if(Expr3='502156' or Expr3='502155' or Expr3='502135' or Expr3='502170',Expr3)" in definition in expressions tab and "fullname" as a dimention
but it just act when i select these values
i want show them without selection
Hi,
try like
in Expression
Only({<Expr3={'502156','502155','502135','502170'}>}Expr3)
Edit :
Or you can create new field in script and use that field in expression
try like
if(Match(Expr3,'502156','502155','502135','502170'),Expr3) as modified_Expr3
and use modified_expr3 in your expression
Regards
What exactly is your expression?? Expr3 outputs a number like this?
Hi,
try like
in Expression
Only({<Expr3={'502156','502155','502135','502170'}>}Expr3)
Edit :
Or you can create new field in script and use that field in expression
try like
if(Match(Expr3,'502156','502155','502135','502170'),Expr3) as modified_Expr3
and use modified_expr3 in your expression
Regards
max I have a feeling that Expr3 is not a field but an expression and that is why I was hesitant to provide a solution before looking at the expression itself. But if it just a field then what you have proposed 1st should work. I am still not sure if the second one will work if it did not work with if(... or....)
Hi,
Yes Sunny without data we can not give any proper solution.
It was just guess.
Dear it-golestan,
If solution don't work, Please provide sample data with expected output.
Regards,