1 Reply Latest reply: Aug 2, 2017 6:49 AM by arul settu RSS

    QlikSense Custom Coloured Bar Chart

    Daniel Berkes

      Hi All,

       

      I have a line chart in QlikSense.

       

      its has

           one dimension MonthYear, and

           two expression

                sum({<Product={'PRODUCT1'}>}Amount) and

                sum({<Product={'PRODUCT2'}>}Amount)


      I would like to assign two different custom colour for each of them and used color by expression with the following formula: IF(match(Product,'PRODUCT1'),colour_2,colour_2).


      it hasnt worked.


      any suggestion?

       

      Thanks,

      Daniel