0 Replies Latest reply: May 8, 2017 7:06 AM by Gaston Tan RSS

    Qlik Sense - Colouring of Stacked bar charts and Combo charts

    Gaston Tan

      Hi everyone,

       

      I would like to ask if there are any solutions for defining colors in Qlik Sense combo or stacked bar charts?

      Currently, the only way that i know of is using the color expression. This is possible if i were to hardcode it.

       

      A sample script of the expression would be:

      if (Count(Name)>= 100, (rgb(8, 9, 10)),

        if (Count(Name)>= 90,(rgb(124, 123, 119)),

        if (Count(Name)>= 56,(rgb(188, 186, 177)),

          if (Count(Name)>= 44,(rgb(224, 178, 11)),

          if (Count(Name)>= 30,(rgb(14, 96, 140)),

              if (Count(Name)>= 15,(rgb(181, 222, 244)), (rgb(249, 249, 247))))))))

       

      However, if i want to color my bars according this expression:

      count({$<[FAKEYN]={"Y"}>} FAKEYN)

      count(APPROVED)

      count({$<[TYPE1]={"2"}>} TYPE1)

      where each expression represents a different variable, i am unable to do so.


      The closest i have gotten to solve this is to use the ColourStyler extension downloaded. What i have done is i have linked the visualization, changed the colors using the extension, unlinked the visualization and  edit the color expression code. BUT, i am only able to colour the entire stacked bar (Same color) instead of them individually. I am also unable to colour the bars specifically. (See before and after)


      Before

      Untitled.png
      After

      Untitled11.png


      Does anyone know how to go about this? Be it an expression that i am unaware of or whether it is a limited capability of QlikSense for now.

      Thanks and regards,

      Gaston