topic greater than a negative value in set analysis in QlikView

greater than a negative value in set analysis

yzhang88 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: greater than a negative value in set analysis

rubenmarin — Mon, 24 Sep 2018 13:48:59 GMT

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)

Re: greater than a negative value in set analysis

yzhang88 — Mon, 24 Sep 2018 13:52:39 GMT

Thank you Ruben, it is exactly what I need

Re: greater than a negative value in set analysis

dplr-rn — Tue, 25 Sep 2018 20:11:49 GMT

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

Re: greater than a negative value in set analysis

rubenmarin — Wed, 26 Sep 2018 06:30:19 GMT

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