Compare class to average

isabelleica — Wed, 26 Sep 2018 12:58:18 GMT

Hello!

I've created a Simple Bar Chart with a dimension using the class function:

=class(Aggr(Sum([Hours]), [Person ID]), 10)

The expression is the amount of people:

=count(DISTINCT [Person ID])

I'm trying to colour the bar where the average of hours per person is found. I can find the average using the formula:

=Avg(Aggr(Sum([Hours]), [Person ID]))

How can I colour the class bar that contains the average?

I'm trying the following formula, but it is not working:

if(

class(Aggr(Sum([Hours]), [Person ID]), 10)

class(Avg(Aggr(Sum([Hours]), [Person ID]), 10))

Red(),

Blue()

)

For example, in the image below, I would like to colour the 110-120 bar as Red (since it contains the average) and the others to remain Blue:

topic Compare class to average in QlikView