2 Replies Latest reply: Jan 10, 2018 1:27 PM by Kenneth Holden RSS

    color by average

    Kenneth Holden

      (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
          omar bensalem

          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:

          Capture.PNG