Discussion board where members can get started with 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.
Are the buckets kown ahead of time?
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,