6 Replies Latest reply: Feb 1, 2017 6:03 AM by Daniel Berkes RSS

    Color By Expression

    Daniel Berkes

      Hi All,


      I have a data modell like this:

          direction values here: in or out

          amount: values here numbers

          date: values here ...


      I would like to make an accumulated line chart (succeeded) which represents the incomes and expenses, and colored the two line with an expression  (not succeeded).


      Dimension: date


           RangeSum(Above(Sum({<direction={'in'}>}amount),0,RowNo())) and




      Color and legend / Colors by expression: if(direction='in',lightred(),lightgreen()).


      Please help me how can I set up the colors with expression for the lines.


      qvf, pic and data are attached.