Build group with AVG as limit value

Thu, 18 Aug 2011 15:48:42 GMT

Hello everybody,

i want to build any groups with the Avarage as limit from Group und Avarage +1 as Start for the next Group.

I start with 0 and go with 100 Steps.

For Example:

Values:

100

The AVG from my Example is 42

That means my first Group Start by 1 and End by 42.

The next Group must then be calculated as follows:

Avg(Values from (42+1) + 100)

...

Do you have any idea?

Thanks!!!

danielrozental — Thu, 18 Aug 2011 19:25:57 GMT

You can have a dimension with two values (Group 1 and Group 2) and then do

if(Group='Group 1', avg(if(Value<=$(=avg(Value)),Value)), avg(if(Value>$(=avg(Value)),Value)))

topic Build group with AVG as limit value in QlikView