2 Replies Latest reply: Dec 14, 2017 9:42 PM by Luis Madriz RSS

    Customizing / Fixing Chart Bar Colors

    Eduardo Gallo

      Hello! I created a master item (Dimension), where I classify if an activity is (on time) or (out of date). I would like to represent this in a chart, but I would like to choose the green color for the activities that are (within the time limit) and (red) for the activities (out of date).

       

      I tried to do this by expression, but I could not do that in QlikSense

       

      Can anyone give me tips on how to solve?

       

      Ex: Master Item (Dimension):

       

      =If(Floor(Aggr(Num((Today() - Max(data_ocorrida))/30),cod_conta)) <= 3,'1 - RELAC. EM DIA','2 - NECES. RELAC.')
      

       

      Ex: Appearance> Presentation> Colors and Caption (By Expression):

      I tried to do this in the expression but the two bars are red.

      It did not work out as I would have liked.

       

      If(Floor(Aggr(Num((Today() - Max(data_ocorrida))/30),cod_conta)) <= 3,Green(), Red())
      

       

      Current results:


      QlikSenseGrafico.png

       

      Expected outcome:

       

      QlikSenseGrafico.png

       

      I'm a beginner and thank you for the attention and help from everyone.

      Thank you!

      Hugs