topic Offset X-axis to 1 in QlikView

Offset X-axis to 1

Sat, 16 Apr 2011 00:02:07 GMT

I want to create a chart with values on Y-axis from 0 to 10 but I need to have the X-axis starting at 1. This means that some of the values will show as 0.25 or 0.9, etc below the X-axis. Does Qlikview has a way to offset the X-axis? Attaching a sample chart.

Offset X-axis to 1

Oleg_Troyansky — Sat, 16 Apr 2011 00:17:06 GMT

Interesting... To the best of my knowledge, - no, not out of the box. I haven't seen any settings that could help you move the Axis up by a certain amount...

I'd say - it would take a lot of tricky work-around solutions to get this chart, or - if you are using ver. 10.0, perhaps you can find a JScript solution and integrate it as an Extension Object...

Offset X-axis to 1

vgutkovsky — Sat, 16 Apr 2011 00:17:57 GMT

Correction: you mean offset the Y-axis to be aligned at X=1. The X-axis itself is not offset. As far as I know, you can't change the positions of the axes themselves. But if your X goes into negatives, then the chart will certainly display that if you don't restrict it with a static min. It's just that the Y-axis will remain on the left side of the screen. By the way, you might get a smoother effect if you set the X-Axis to Continuous in the Axes tab, since it sounds like your X-axis is actually a number.

Regards,

Offset X-axis to 1

johnw — Sat, 16 Apr 2011 01:08:18 GMT

Subtract 1 from the ratio, THEN on the expressions tab, click on the little + next to the expression, click on Bar Offset, and enter 1. For the axis, go to the presentation tab, click "Add" in the Reference Lines section, and enter 1 for the expression. See attached.

Edit: Added dual() to the expression so that it would display the right number when you mouse over, instead of the number - 1.

Offset X-axis to 1

johnw — Sat, 16 Apr 2011 01:18:13 GMT

Grrr... the forum is INSISTING on keeping my old attachment in the above post, no matter how many times I replace it. See attached for the fixed version

Offset X-axis to 1

Oleg_Troyansky — Sat, 16 Apr 2011 19:16:05 GMT

Very nice work-around, John! Quite ingenious!

Offset X-axis to 1

Mon, 18 Apr 2011 23:04:02 GMT

Thank you so much John. This is absolutely brilliant.

I managed to offset the X-axis to 1 by using the solution you have provided. I am having trouble with the dual function though. Not sure what I am doing that is not correct. The results I am getting for the values below the X-axis are not correct. For example, where I should have a 0.38. Instead I am getting a -0.62 OR where I should have 0.9, it is showing up as -0.1

This is the expression I am using. Can you help me figure out what might be the problem:

dual(sum(if(DateFlagCurrQTD=1 or DateFlagPrevQTDMinusZero=1 or DateFlagPrevQTDMinusOne=1 or DateFlagPrevQTDMinusTwo=1 or DateFlagPrevQTDMinusThree=1,BOOKING_AMT/1000))/
sum(if(DateFlagCurrQTD=1 or DateFlagPrevQTDMinusZero=1 or DateFlagPrevQTDMinusOne=1 or DateFlagPrevQTDMinusTwo=1 or DateFlagPrevQTDMinusThree=1,REVENUE_AMT/1000)),
sum(if(DateFlagCurrQTD=1 or DateFlagPrevQTDMinusZero=1 or DateFlagPrevQTDMinusOne=1 or DateFlagPrevQTDMinusTwo=1 or DateFlagPrevQTDMinusThree=1,BOOKING_AMT/1000))/
sum(if(DateFlagCurrQTD=1 or DateFlagPrevQTDMinusZero=1 or DateFlagPrevQTDMinusOne=1 or DateFlagPrevQTDMinusTwo=1 or DateFlagPrevQTDMinusThree=1,REVENUE_AMT/1000))-1)

Offset X-axis to 1

johnw — Mon, 18 Apr 2011 23:44:18 GMT

I don't see the problem with your dual() expression, I'm afraid. It seems like it should work.

Offset X-axis to 1

Mon, 25 Apr 2011 20:16:40 GMT

Offset X-axis to 1

Mon, 25 Apr 2011 20:21:31 GMT

John,

I was having this problem because in the Chart properties (Number tab), I had formatted the numbers to "Fixed to" and 2 decimal places. I removed the formatting from the Number format settings and set it back to default. Instead, I added the Num function to my dual expression to limit it to two decimal places and now it is working perfectly!

Thanks a ton for all your help.

Roopali

Re: Offset X-axis to 1

Christian_Lauritzen — Thu, 20 Feb 2014 16:22:23 GMT

Clever! /Christian