3 Replies Latest reply: Sep 5, 2016 5:57 AM by Ainhoa Sayans Alberti RSS

    Qlik Sense custom bar chart color by measure value

    Ainhoa Sayans Alberti

      Hello everyone,

       

      I have been searching for this for a while and cant take it. I have a bar chart that shows tons soled for month.

      As we need for other porpouses all years data, but for this chart only this year data we use this formula as measure

       

      sum( {$<Date={">=$(=timestamp(yearStart(Today())))<=$(=timestamp(yearend(Today())))"} > } [Tons sold])

       

      And the value of month as dimensión.

       

      I want that the bars take red or green color if they are (the value of the bar) bigger of certain value.

      I mean maybe Januari and Agust must be in red and the rest of the chart in green.

       

      I thik I have to use color by expresión, but when I put the expresión

      if(sum([Tons sold])>xValue,red(),green())

      All the bars turn green couse is taking all the Tons sol in all time to compare.