Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

RangeAvg using dimensions

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))

Labels (1)
5 Replies
Gysbert_Wassenaar

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?


talk is cheap, supply exceeds demand
tmumaw
Specialist II
Specialist II
Author

 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?

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
tmumaw
Specialist II
Specialist II
Author

Nope.

 

tmumaw
Specialist II
Specialist II
Author

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.