topic Re: Set Analysis Interval in QlikView

Set Analysis Interval

Fri, 25 Jan 2013 16:26:03 GMT

Greetings!

My question is simple, but could not get an answer by referring to the forum, or the Reference Manual. I have a field X with values between 300 and -120. I need to sum the field Y values that are between 1 and 30 of the X and it tried to use Set Analysis, but it still fails:

Sum({<X={'<=30'}, X={'>=1'}>} Y) or

Sum({<X={'<=30','>=1'} Y)

Where I went wrong?

grateful

Stive

Brazil

Re: Set Analysis Interval

Gysbert_Wassenaar — Fri, 25 Jan 2013 16:44:52 GMT

try sum({<X={">=1<=30"}>} Y)

Re: Set Analysis Interval

sbaldwin — Fri, 25 Jan 2013 16:47:06 GMT

Hi try someting like:

Sum({<X={'<=30'}>*<X={'>=1'}>} Y)

Thanks

Steve

Re: Set Analysis Interval

Fri, 25 Jan 2013 16:53:03 GMT

Mr. Gysbert,

It was perfect!

Thank You!

Stive

Re: Set Analysis Interval

Fri, 25 Jan 2013 16:54:05 GMT

sbaldwin,

Its solution is also perfect!

Thanks for the attention!