topic Re: Combo Chart with % in QlikView

Combo Chart with %

khaycock — Sat, 16 Nov 2024 02:50:37 GMT

I'm trying to make a combo chart with counts of values as the bars and a % value of the bars as a line but the line is white and sits below all the bars.

The values on the data points are correct but I was hoping it would have another axis on the right or something to make the line a bit more meaningful than just at the bottom.

Is there any better ways to show this?

Re: Combo Chart with %

m_woolf — Thu, 01 Aug 2019 11:48:37 GMT

Go to Chart|Properties|Axes.
Select the expression for the line and select Position Right (Top)

Re: Combo Chart with %

khaycock — Thu, 01 Aug 2019 11:52:26 GMT

Amazing thanks! Do you know how to change the colour of the line from White to any other colour?

Re: Combo Chart with %

m_woolf — Thu, 01 Aug 2019 12:02:02 GMT

Chart Pproperties|Expressions.

Click the + in front of the expression for the line.
Click Background Color.

Color can be entered as:
Color(1), Color(2), ... OR
rgb(235,55,77)