Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Build group with AVG as limit value

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:

1

2

9

5

50

55

66

88

99

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

1 Reply
danielrozental
Master II
Master II

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