topic Re: Qlikview: Color coding a single bar chart with multiple expressions in QlikView

Qlikview: Color coding a single bar chart with multiple expressions

sqlpuzzle — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a barchart that has two expressions "Number of Sales" and "Average Sales Amount"

I want to color code only the "Average Sales Amount" bar by the Gender Dimension. The chart should look similar to below.

I am attaching my sample qvw.

Re: Qlikview: Color coding a single bar chart with multiple expressions

Anil_Babu_Samineni — Thu, 25 Oct 2018 06:33:55 GMT

Not sure - i understand the request for below one

I want to color code only the "Average Sales Amount" bar by the Gender Dimension.

Re: Qlikview: Color coding a single bar chart with multiple expressions

sqlpuzzle — Thu, 25 Oct 2018 13:07:29 GMT

There is a Gender Dimension, I want to add it to the Chart and make only the Average Sales Amount bar get colored by the gender dimension. Similar to below. Only the bar for "Average Sales Amount" should be affected the "Number of Sales" bar should not be affected.

Re: Qlikview: Color coding a single bar chart with multiple expressions

stigchel — Thu, 25 Oct 2018 14:21:04 GMT

It think this is the closest you can get to what you want, or you should stack all bars.

Split the Average Sales Amount expression into the two gender values e.g.

= AVG({<Gender={'M'}>}SalesAmount)

and use an offset for the second gender expression

Also see attached

Re: Qlikview: Color coding a single bar chart with multiple expressions

stigchel — Thu, 25 Oct 2018 14:57:36 GMT

With some playing around, I actually got it looking like you suggested

Se also attached

Re: Qlikview: Color coding a single bar chart with multiple expressions

sqlpuzzle — Thu, 25 Oct 2018 20:03:50 GMT

This works even though I am struggling to understand the solution.

Re: Qlikview: Color coding a single bar chart with multiple expressions

stigchel — Fri, 26 Oct 2018 11:04:58 GMT

Instead of a Gender dimension that would split the Number of Sales expression as well and would display Gender=M or F in the mouse over, I used a synthetic dimension ValueList with two values. I've hided the legend for this dimension, so it does not display in the x axis. It does in the mouse over, but with a rather anonymous group=1 or 2 (you could alter the label to 'Bar', so it would display Bar =1 or 2).

All the expressions only result in a value for one of the two values from the synthetic dimension, 0 and Null values are not displayed in the chart. The Number of sales expression has a value for Group 1 (or Bar 1 as you will) and the two Average Sales Amount expressions (split by gender) have a value for Group=2.