topic Chart set y-axis cross point in QlikView

Chart set y-axis cross point

Wed, 20 Jul 2011 09:23:44 GMT

Hi Everyone,

I have a bar chart and I need the y-axis to cross the x-axis at 100 rather than zero. I cannot find an option for the cross point? Basically I need everything that is less than 100 to go to the left and everything greater than 100 to be on the right.

Thanks

Gareth

Chart set y-axis cross point

kaushiknsolanki — Wed, 20 Jul 2011 09:42:56 GMT

Hi,

Why dont you use the reference line for that.

Go to properties -> Presentation tab -> Reference line -> Add

Add the expression

Regards,

Kaushik Solanki

Chart set y-axis cross point

Wed, 20 Jul 2011 09:54:22 GMT

Hi Kaushik,

Unfortunately a reference line is simply an overlaid line. I need for the bar chart to actually run with a '0' being at 100 (i.e. just change the cross point of the x and y).

So rather than the following:

| xxxx

| xx

| xxxxxxx

| xxxxx

it would look like this:

| xx

xx |

| xxxxx

| xxx

Sorry for my bad drawing

Thanks

Gareth

Chart set y-axis cross point

pat_agen — Wed, 20 Jul 2011 09:57:18 GMT

hi,

John Witherspoon showed how to offset the x-axis in this post

http://community.qlik.com/message/111600#111600

maybe there is something in there for you

Chart set y-axis cross point

kaushiknsolanki — Wed, 20 Jul 2011 09:58:21 GMT

Hi,

I think its not possible to get y axis at value 100.

Regards,

Kaushik Solanki