topic Re: Greater than and less than in QlikView

Greater than and less than

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am trying to understand how greater than and less than work.

Field1

-1

Expression1= count({<[field1]={'<10>0'}>} [field2]) =3

Expresion2= count({<[field1]={'>10<0'}>} [field2]) =2

It seems like Expression1 looks at the 5 available options, removes the value that is greater than 10, and that leaves -1,4,5,6. It then appears to use those and evaluates those to see which ones are greater than 0 and that leaves 3 remaining values. This does not appear to be an OR statement.

It seems like Expression2 is an OR statement. If the value is greater than 10 or less than 0 then count. Expression2=2.

Why does the one seem to behave as an OR statement and not the other?

Thanks for the help!

Re: Greater than and less than

Sat, 21 Jan 2017 07:41:16 GMT

Try changing Expreson2 to Expression2 for ur variable?

Just a thought after looking,

Might not fix it but I'm not looking at the data

Seems like it might have been overlooked,

Let me know if I can help further,

Tom

Re: Greater than and less than

Gysbert_Wassenaar — Sat, 21 Jan 2017 08:38:40 GMT

Yeah, that's the way numeric search works. In the first expression it's an AND because an OR wouldn't make sense. You'd select everything. In the second expression it's an OR. Again because an AND wouldn't make sense. You'd get no results at all.

Re: Greater than and less than

swuehl — Sun, 22 Jan 2017 12:03:30 GMT

Gysbert is absolutely right about this not well discussed and even less documented behaviour of the numeric search.

I've only found

Re: compare a dollar amount <> 0

I just want to emphasize on my last statement therein:

"And one needs to consider this if the search limits are not literals, but dynamically derived from other fields etc.

(For example when you expect always StartTime < EndTime, but when your data proves something else...)"

Due to the behaviour of numeric search, unintentionally mixed up limits might lead to unexpected, incorrect (compared to your requirements) aggregation results.

Re: Greater than and less than

MarcoWedel — Mon, 23 Jan 2017 22:23:36 GMT

Hi,

maybe using expression search helps to explicitly define the expected logical operator:

field1={"=field1<10 and field1>0"}

field1={"=field1>10 or field1<0"}

regards

Marco