topic Re: color by average in Visualization and Usability

color by average

Anonymous — Wed, 10 Jan 2018 16:42:43 GMT

(Count(distinct([CREATED_DT.autoCalendar.Date]))/((Count({<supervisor=>}TOTAL distinct([CREATED_DT.autoCalendar.Date])))*.75))

the above is an expression that works.

I am now trying to color by average of this column the text color.

For a color expression, how do i tell qlik to color anything above average as green and anything below average as red.

thanks!

Re: color by average

OmarBenSalem — Wed, 10 Jan 2018 18:12:40 GMT

what the dimension you're using in the chart where u're using this chart?

Let's say it called MyDimension:

in this chart, under adds on, create a reference line as follow( to test if we're doing things well?)

Avg(All aggr((Count(distinct([CREATED_DT.autoCalendar.Date]))/((Count({<supervisor=>}TOTAL distinct([CREATED_DT.autoCalendar.Date])))*.75)),MyDimension))

and as an expression color:

if((Count(distinct([CREATED_DT.autoCalendar.Date]))/((Count({<supervisor=>}TOTAL distinct([CREATED_DT.autoCalendar.Date])))*.75))

>= Avg(All aggr((Count(distinct([CREATED_DT.autoCalendar.Date]))/((Count({<supervisor=>}TOTAL distinct([CREATED_DT.autoCalendar.Date])))*.75)),MyDimension))

, green(), red())

per analogy to my data, the resutlt would be:

Re: color by average

Anonymous — Wed, 10 Jan 2018 18:27:44 GMT

That worked, thank you.