show specific value in chart

[Anonymous]

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

[sunny_talwar]

What exactly is your expression?? Expr3 outputs a number like this?

[PrashantSangle · Accepted solution]

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

[sunny_talwar]

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....)

[PrashantSangle]

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,

[sunny_talwar]