topic Need some help with Set Analysis in QlikView

Need some help with Set Analysis

tomhovens — Tue, 17 May 2016 13:14:17 GMT

Hi All,

I'm trying to create a function to calculate an average of 461nm VIS based on specific values.

Rangnr is the rank per record 1,2,3 etc.

2880 is an solid number but the next number 4647 is a function avg(Rangnr)

avg({1<Rangnr={">2880<=4647"}>}461nmVis)

4647 is a dynamic number and will change based on the amount of data

sunny_talwar — Tue, 17 May 2016 13:16:21 GMT

May be this:

Avg({1<Rangnr={">2880<=$(=Avg(Rangnr))"}>}461nmVis)

swuehl — Tue, 17 May 2016 13:20:13 GMT

To avoid a misinterpretation of a potentially returned floating point value from the avg(), use an additional Floor() function:

Avg({1<Rangnr={">2880<=$(=Floor(Avg(Rangnr)))"}>}461nmVis)

edit: Any you may want to also use set identifier 1 in the avg() function;

Avg({1<Rangnr={">2880<=$(=Floor(Avg({1} Rangnr)))"}>}461nmVis)