topic Re: Why doesn't this simple line background colour expression work? in QlikView

Why doesn't this simple line background colour expression work?

jblomqvist — Fri, 19 Aug 2016 16:16:23 GMT

Hi,

I have the following chart:

Dimension: MonthYear

Expression: Count(Distinct OrderID)

In background colour for the expression is If(Count(DISTINCT OrderID) > $(vAVGOrders), LightBlue(), LightGreen())

My variable vAVGOrders expression is: Avg(Aggr(Count(DISTINCT OrderID), MonthYear))

Why doesn't my chart above change to lightblue colour when the line is going over Avg # Orders? What do I need to change please?

Re: Why doesn't this simple line background colour expression work?

Gysbert_Wassenaar — Fri, 19 Aug 2016 16:23:08 GMT

Put an = character in front of the expression in the variable so that it's calculated outside the context of the chart. Otherwise it will be calculated for every MonthYear value and then the average is always the same as the count because the average will be calculated on only one value.

Re: Why doesn't this simple line background colour expression work?

sunny_talwar — Fri, 19 Aug 2016 16:25:11 GMT

May be try with this as your variable:

Avg(TOTALAggr(Count(DISTINCT OrderID), MonthYear))

Re: Why doesn't this simple line background colour expression work?

jblomqvist — Fri, 19 Aug 2016 16:32:23 GMT

Thanks guys you are both correct.