Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Sum Rangeavg

this is the result of a rangesum

clipboard_image_0.png

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

Accepted Solutions
Partner
Partner

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.

View solution in original post

4 Replies
Partner
Partner

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.

View solution in original post

Contributor II
Contributor II

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.

Partner
Partner

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

MVP & Luminary
MVP & Luminary

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

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

- Marcus