Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

greater than a negative value in set analysis

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.

1 Solution

Accepted Solutions
Highlighted

Re: greater than a negative value in set analysis

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)

View solution in original post

4 Replies
Highlighted

Re: greater than a negative value in set analysis

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)

View solution in original post

Highlighted
Contributor III
Contributor III

Re: greater than a negative value in set analysis

Thank you Ruben, it is exactly what I need

Highlighted
Partner
Partner

Re: greater than a negative value in set analysis

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

Highlighted

Re: greater than a negative value in set analysis

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*"}