topic Modifying Bar Chart Axis Text in QlikView

Modifying Bar Chart Axis Text

Mon, 23 Jan 2012 15:38:14 GMT

Greetings all.

I have a bar chart which is displaying individual variance from group average.

Say the following:

John 10

Lisa 20

Jane 30

The chart correctly lists -10,0,10 as variance from average.

However, what the client would like to see, is instead of 0, have the baseline be the average of 20, and then would list -10 and +10 for the outliers.

Is there a simple way to accomplish this?

Thank you in advance for your time and consideration.

Modifying Bar Chart Axis Text

Oleg_Troyansky — Mon, 23 Jan 2012 15:59:43 GMT

I'm not sure you can modify the axis, but you can make the same impression with the following:

- Hide the original axis.

- Create a Reference line with the desired formula for the Average as the new "axis"

- Use the same formula to calculate the "Bar Offset" for your main Expression (to see "Offset" and other Expression Attributes, click on the plus next to the expression )

cheers,

Oleg

Modifying Bar Chart Axis Text

Mon, 23 Jan 2012 16:07:00 GMT

Thanks for the reply Oleg.

That definitely sounds like it will work!