Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Duck
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
 
Labels (1)
1 Solution

Accepted Solutions
wade12
Partner - Creator II
Partner - Creator II

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
wade12
Partner - Creator II
Partner - Creator II

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.

Duck
Contributor II
Contributor II
Author

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.

wade12
Partner - Creator II
Partner - Creator II

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

marcus_sommer
MVP
MVP

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

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

- Marcus