Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

stacked bar graph with fixed colors

Hey guys,

I have a stacked bar graph, there's 2 values on top of each other and now I would like to make the color for the first bar green and the color for the second bar on top of that, red. Can I do this with an expression and how? It's not depending on the value, just want to make the bottom bar green and the one on top of it, red.

Thanks a bunch!

Toon

5 Replies
spividori
Valued Contributor

Re: stacked bar graph with fixed colors

Hi.

In my example I have data for the years 2009 and 2010 and set the colors for each year as follows:

Capture2.PNG

Hope this help!

Regards.

Not applicable

Re: stacked bar graph with fixed colors

Hi,

Thanks for the reply, I have actually tried something like this but this considers the value of year, correct? I have 2 stacked bars, I'd like the bottom bar to have a specific color and the top one to have a different color. Not based on the actual values.

Thanks in advance for suggestions,

Toon

Not applicable

Re: stacked bar graph with fixed colors

So I have 1 dimension and 2 measures, I want measure 1 to be a certain color and measure 2 in another color. Maybe I have to use a valuelist? Not sure about the correct way to go, I am using dates for both measures.

Thanks for any suggestions,

Toon

Not applicable

Re: stacked bar graph with fixed colors

Found it after fiddling around a bit more, solution based on Qlik Sense: How to set custom colors by measure in a bar chart.

I removed my Dimensions and added a Measure with Duration which is a ValueList('Start','Duration'). Then I added a Measure with the expression if(ValueList('Start','Duration')='Start', Start, if(ValueList('Start','Duration')='Duration', [Date Deliver]-Start)). My problem here was I couldn't add a new Dimension because I had 2 Measures already. It only allowed me to create a new Dimension after removing the Measures.

NOTE: Start, Duration and [Date Deliver] come from my excel file and was manipulated in the Data connections

The color code was then rather simple: if(ValueList('Start','Duration')='Start', white(), if(ValueList('Start','Duration')='Duration',rgb(192,0,192))). Basically I was creating a Gantt chart here.

Thanks forum,

Toon

reddys310
Honored Contributor II

Re: stacked bar graph with fixed colors

Hi Toon,

Check this out:

Capture.PNG

Find the sample qvf attached.

- Sangram

Community Browser