topic SetAnalysis with Fields range in QlikView

SetAnalysis with Fields range

Anonymous — Mon, 22 May 2017 11:29:31 GMT

I need to calculate Result field which is AVG of AVG_VAL but its take only range between MinRange and MaxRange.

I try to wrote this:

Avg({<Attenuator = {'>=MinRange<=MaxRange' }>}AVG_Val)

But didn't get any result.

Any suggestions?

Thanks

Ravit.

Re: SetAnalysis with Fields range

sunny_talwar — Mon, 22 May 2017 11:31:58 GMT

Set analysis is evaluated once per chart, you may have to use Aggr() with if or just if statement here? Can you share if MinRange and MaxRange are expression or a hard-coded value?

Re: SetAnalysis with Fields range

Anonymous — Mon, 22 May 2017 11:50:02 GMT

MinRange and MaxRange are database fields. that can be dynamic and change each row.

Re: SetAnalysis with Fields range

sunny_talwar — Mon, 22 May 2017 11:54:17 GMT

Oh okay, I got you... are they going to be used as a dimension in this chart? If they will be, then may be this

Avg(If(Attenuator >= MinRange and Attenuator <= MaxRange, AVG_Val))

Re: SetAnalysis with Fields range

Anonymous — Mon, 22 May 2017 12:07:09 GMT

Thanks a lot!