topic Re: RangeAvg using dimensions in QlikView

RangeAvg using dimensions

tmumaw — Sat, 16 Nov 2024 04:36:48 GMT

Good Morning everyone,

Simple question I'm trying to use the RangeAvg with dimensions. For some reason it does not like my statement....any ideas.....Thanks

RangeAvg(Before(Count({<YR5_SW = {1}>}DISTINCT Total([Sold To]),0,5)),GrowthType))

Re: RangeAvg using dimensions

Gysbert_Wassenaar — Wed, 30 Jan 2019 16:42:54 GMT

The RangeAvg function only averages all its arguments. It doesn't not use any arguments as dimensions like the aggr function does. Can you explain what you're trying to do?

Re: RangeAvg using dimensions

tmumaw — Wed, 30 Jan 2019 16:52:14 GMT

I have a pivot table with years across the top and offices down the side. I want to add another dimension to the pivot table called GrowthType. It works fine with one dimension, but when I add the second the RangeAvg does not work. Any ideas?

Re: RangeAvg using dimensions

Gysbert_Wassenaar — Wed, 30 Jan 2019 17:03:20 GMT

Try adding the Total qualifier to the Before function: rangeavg(before total count(....) ,0,5))

Re: RangeAvg using dimensions

tmumaw — Wed, 30 Jan 2019 19:04:56 GMT

Nope.

Re: RangeAvg using dimensions

tmumaw — Mon, 11 Feb 2019 16:33:56 GMT

I have 3 dimensions in my pivot table one Operations Groups and the other being Offices with in the group, then across the top I have Growth Type (Organic and Non-Organic) It works fine with either Operation Groups or Offices, but when I add both it returns zeros.