3 Replies Latest reply: Apr 27, 2017 12:38 PM by Vijay Vira RSS

    Visual Cues based on % Change

    David McFall

      Hi,

       

      I am using QlikView 11, and need to change the colour of a cell based on the improvement/decline of a customers sales month on month. I've created my chart with Jan, Feb, Mar and Apr

       

      For example, Jan was £1,548, Feb was £747, Mar was £1,160 and Apr was £1,325. The targets set are that Feb needs to be 10% more than Jan, Mar needs to be 10% more than Feb and Apr needs to be 10% more than Mar. If it isn't, go red, if it is go green.

       

      Any help is appreciated.

       

      Regards

       

      David

        • Re: Visual Cues based on % Change
          Vijay Vira

          Hi,

           

           

          LOAD * INLINE [
          Month, Amt
          Jan, 1548
          Feb, 747
          Mar, 1160
          Apr, 1325
          ]
          ;

           

          ThresholdColor.PNG

           

          Row # Column

           

           

           

          =RowNo(TOTAL)

           

          Diff Column

           

          =If(RowNo(TOTAL) > 1, If(Above(TOTAL Amt,1) > 0, Num((Amt-Above(TOTAL Amt,1))*100/Above(TOTAL Amt,1), '#.##')))

           

          TextColor.PNG

           

          =If(Num((Amt-Above(TOTAL Amt,1))*100/Above(TOTAL Amt,1), '#.##') < 10, RGB(255,0,0), RGB(0,255,0))

           

           

           

           

           

           

           

          • Re: Visual Cues based on % Change
            David McFall

            Hi,

             

            I'm calculating the totals using expressions, like this..

             

            Sum (if (InMonth (Date, Today(), -3), [Sales Revenue])) then -2, -1 etc. to give me the sales for the previous months.

             

            Where would I put the coding for this?

             

            Regards

             

            David