10 Replies Latest reply: Feb 9, 2017 12:29 PM by eeacrw cewdbr RSS

    Qlik Sense - Bar Chart - change bar color based on Column name

    eeacrw cewdbr

      Hello,

      I have a bar chart, and 2 table columns with figures.

      How can I manually choose color for each of bars?

       

      Load * Inline [

      month, bar1, bar2

      1, 10, 12

      2, 13, 15

      3, 12, 17

      ];

       

      I'm looking for expression like    =if(FieldName='bar1', rgb(87,87,150), rgb(150,100,100) )

      But there is no function to get fieldname (column name) in Sense, right?

       

      So, how can we solve the problem?