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

    Color By Expression

    Daniel Berkes
    Daniel Berkes Feb 1, 2017 4:57 AM

      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

      Measures:

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

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

       

      Coloring:

      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.

       

      Thanks,

      Daniel