Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
vsabbise
Creator
Creator

How do I create Average(mean) of a bucketed Measure in Qlik Sense ?

Suppose I have a measure having 3 buckets. 100k to 200k , 200k to 500k , 500k to 1M. How do I take a average of the measure based on buckets ? I.e, Average(Measure) where bucket = 100k to 200k ? .

I would need to plot this data for a dimension. So, instead of bucketed measure, I would need mean of the bucketed measure over the dimension.

3 Replies
JustinDallas
Specialist III
Specialist III

Are the buckets kown ahead of time?

vsabbise
Creator
Creator
Author

Yes. Thanks

CarlosAMonroy
Creator III
Creator III

Hi Vamsi,

If you happen to have the buckets in the script, I guess you can use aggr to achieve what you are looking for.

Hope that helps,

Carlos