topic Re: Line Graph Questions in QlikView

Line Graph Questions

Anonymous — Wed, 09 Sep 2015 18:51:21 GMT

Does anyone know why Qlikview squishes your data points tighter and leaves space at the begging and end of your x-axis as you expand your x axis? Is there a fix to this? Formatting the x-axis does not fix this either, very odd.

Also, my understanding is that the number format will not apply unless you create a static step. Is this correct?

Re: Line Graph Questions

Wed, 09 Sep 2015 18:53:27 GMT

I am not sure what you mean by number format.

as far as the squishing goes, click somewhere in your chart without making selections and do ctrl-shift

You will see red borders around the various parts of the chart - try draging the ends to resize

Re: Line Graph Questions

Anonymous — Wed, 09 Sep 2015 18:58:46 GMT

Changing the the boarders around the chart does not impact this.

By number format I mean the number format set in the object. As you can see in my picture there is only one decimal but the number format is set to 2. I read somewhere that the chart will ignore the number format setting you have unless you have a static step. I tried that and it appears correct. I'm just wondering if that is truly how its suppose to work. You should be able to control the number format in the number format tab in my opinion. Not sure what the logic is here.

Re: Line Graph Questions

Anonymous — Tue, 15 Sep 2015 02:18:36 GMT

OK, I think I figured this out. I think it has to do with selecting the Continuous option for the Dimension Axis in the Axes tab. The graph is the same but it adjust the axis labels to fit the space. If you dont select continuous it doesnt know how to space out the labels (I guess). It still does not start and end the graph at the min/max but it does look better.

Re: Line Graph Questions

Anonymous — Tue, 15 Sep 2015 15:46:52 GMT

Ok, final installment of the final solution to my original question. I have now figured out what is needed to bring the line chart to the edges of the chart. Once you have established the axis is continuous, you can create a formula for static min and max. This will ensure your graph starts and stops at the edges. Here is my formula for static min: =min(GetFieldSelections(Month_Year)). I also have added a reference line that plots the average of the time period presented.