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:



      Expected outcome:




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

      Thank you!