topic Re: X Axis with continuous dates in QlikView

X Axis with continuous dates

Anonymous — Mon, 21 Sep 2015 14:21:47 GMT

My data set has dates. The data represents monthly averages (not loading daily data) and given the first of the month as the date. When I create a graph, the X axis is populated with the dates in between. I dont want this but cant figure out how to get rid of. I have the axis set to continuous and need it that way when showing longer time periods (more than 1 year). I dont have this issue when more than one year is graphed. I have suppress zero values and missing on.

Re: X Axis with continuous dates

agni_gold — Mon, 21 Sep 2015 14:26:38 GMT

Please post your sample appication

Re: X Axis with continuous dates

jonathandienst — Mon, 21 Sep 2015 14:34:44 GMT

That's what you get when you set the axis to continuous.

But if the data is monthly, you could manually scale the axis to 30.44 days. I don't think there is any way (with a continuous axis) of making it strictly monthly, but it may be good enough with that scale and the axis format set to MMM-YY (or similar without the day number)

Re: X Axis with continuous dates

Anonymous — Mon, 21 Sep 2015 14:43:52 GMT

Ok, this is the correct answer per my testing. The only issue (which is minor) is the last data point doesn't get an x-axis label. I suspect there is no solution to this but if you have one I would be interested. Thanks for your help.

PS - How did you come up with 30.44?