4 Replies Latest reply: Jun 23, 2016 1:40 PM by Lauren Mills RSS

    Color by Expression in a Stacked Bar Chart in Qlik Sense

    Lauren Mills

      Hello,

       

      PLEASE HELP!!! I have googled and youtubed looking for help and haven't found it....

          

       

      The problem ....

       

      Dimension - (Drill-down) Regional Training, BC , Dist, Dealer Code

      Measure - Count of Students that have a "Y" status and a Count of Students that have a "N" status:

      Measure 1 = Count({$<[LEVEL 1 COMPLETION]={"Y"}>} distinct SID)

      Measure 2 = Count({$<[LEVEL 1 COMPLETION]={"N"}>} distinct SID)

       

      I want to be able to write an expression (if that is the easiest way) to color by measure... N = Red and Y = Green.

       

      It seems so simple but I can't figure it out. Please help ASAP! Thanks!