Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
vsabbise
New Contributor III

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
Valued Contributor II

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

Are the buckets kown ahead of time?

vsabbise
New Contributor III

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

Yes. Thanks

CarlosAMonroy
Contributor III

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

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