Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gameoverzx
New Contributor III

Qlik Sense - Colouring of Stacked bar charts and Combo charts

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


1 Reply
jonvitale
Contributor III

Re: Qlik Sense - Colouring of Stacked bar charts and Combo charts

Gaston,

A half year later... are you still working on this?

First of all, what does the "after" picture represent?

Also, I'm not sure I understand your requirements. Do you want each bar to be colored by its own, distinct expression?