greater than a negative value in set analysis

[yzhang88]

Hi, I want to sum(values) when x is between (-100, 20) in expression:

sum({<x ={'>-100'}, x={'<=20'}>} values)

can someone help me get correct expression?  x ={'>-100'} part doesn't work. Thanks.

[rubenmarin · Accepted solution]

Hi Ying, simple quotes is usually used to look for literals, double quotes for searchs; also, if you use the same field two times only the last is kept, try with:

Sum({<x={">-100<=20"}>} values)

[yzhang88]

Thank you Ruben, it is exactly what I need

[dplr-rn]

Ruben are there any situations where double quotes is not recommended.

[rubenmarin]

Hi Dilip, I'm not sure of recommendations, but I use single quotes for literals, when there is an exact text to filter like:

Option={'Y'}

And Iuse doube quotes if there are is comparison simbol (=,<,>) or a star character like:

Option={"Y*"}