topic Re: Sum Rangeavg in QlikView

Sum Rangeavg

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

this is the result of a rangesum

how to sum the rangeavg result and arrive at a unique value?
459.719

Re: Sum Rangeavg

wade12 — Fri, 06 Sep 2019 12:17:28 GMT

not sure i fully understand your question,

but if i create a text box and use the expression

=RangeAvg(1,2,3,4) + RangeAvg(5,6,7,8)

then i get 9 as the correct result.

hope this helps.

Re: Sum Rangeavg

Duck — Fri, 06 Sep 2019 12:55:35 GMT

I understand, but in this situation I should individualize the means, rangeavg (1) + rangeavg (2) + rangeavg (3), but what if there are many values. must have a way of grouping these values automatically.

Re: Sum Rangeavg

wade12 — Fri, 06 Sep 2019 13:38:11 GMT

maybe code it in the load script and use a for loop to iterate through the many values.

Re: Sum Rangeavg

marcus_sommer — Fri, 06 Sep 2019 14:11:19 GMT

The example is rather confusing ... but I assume you want to do something like this:

sum(aggr(rangeavg(YourContent), unidade_calc))

- Marcus