0 Replies Latest reply: Apr 15, 2015 9:34 AM by rustam mashrapov RSS

    custom color for lagged variables..with Above function?

      Hi all,

       

      I have two variables:

      1)current:

      Count(ALERTDATE)

      2) average of last two periods ( I used above function get the average of t-n period) :

          (Above(Count(ALERTDATE),1,1) +Above(Count(ALERTDATE),2,1))/2

      See the pic below:

       

      Qlik Sense built seleciton: Multicolor enables me to get the different colors for both. But I want to use another customized color.

      How do i integrate second variable in the color code, if it is created by above function????

       

      I want for example: count(ALERTDATE), green()

                            +     (Above(Count(ALERTDATE),1,1) +Above(Count(ALERTDATE),2,1))/2, red()

       

      tx you in advance,

       

      best

       

      Rustam

       

       

       

       

      Sample.jpg