topic Re: Continuous Dimension axis - how to return just one axis label per month? in QlikView

Continuous Dimension axis - how to return just one axis label per month?

Wed, 22 Feb 2012 12:03:40 GMT

Hello all.

I have a line graph with the dimension MonthName(full_date) and the expression median(LOS_IncLeave).

I need each month to appear on the X axis once, even if there isn’t an expression value for a particular month. I can get this working if I check Continuous for the dimension axis.

However, if I check Continuous for the dimension axis then I get more than one label per month.

If I uncheck Continuous for the dimension axis then I get one label per month but then the months without an expression value disappear.

Any suggestions?

I realise there are similar threads on the forum however none of them seem to work when I use MonthName(full_date).

Thanks in advance, Michael.

Continuous Dimension axis - how to return just one axis label per month?

Wed, 22 Feb 2012 12:10:52 GMT

Now working if I put 30 (average number of days per month) as the static step.

Seems a bit clunky so I’d be interested to hear if there’s a cleaner solution.

Thanks, M.

Continuous Dimension axis - how to return just one axis label per month?

swuehl — Wed, 22 Feb 2012 12:13:27 GMT

Are you using a (master) calendar that contain all Monthname values or only values where you have expression values, too? If latter, creating a Master calendar might be first part of a solution, please search the forum for some already available solutions.

Then, check if 'suppress zero values' is activated, if so, uncheck. Suppress zero values will remove all lines where all expression values are zero.

Hope this helps,

Stefan

Continuous Dimension axis - how to return just one axis label per month?

swuehl — Wed, 22 Feb 2012 12:19:02 GMT

Using a static step might help, but I have found the display depending on graph size. QV seems to automatically decide how many dimension values to show for a continuous axis, also depending on graph size. So there might be some issues coming up when you add more values or resize your graph.

Re: Continuous Dimension axis - how to return just one axis label per month?

pennetzdorfer — Wed, 25 Jul 2012 09:03:16 GMT

Hi,

did you manage to find a static step formula in the meantime?

I tried something like =Day(MonthEnd(Date)) which returns the number of days for every month ... but no effect. Dimension values still depend on graph size.