Solved: X Axis with continuous dates - Qlik Community

Anonymous · ‎2015-09-21

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.

Anonymous · ‎2015-09-21

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?

View solution in original post

agni_gold · ‎2015-09-21

Please post your sample appication

jonathandienst · ‎2015-09-21

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Anonymous · ‎2015-09-21

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?