Discussion Board for collaboration on QlikView Layout & Visualizations.
I am looking at something like this: but I want to show that before 1 July 2017 - the assumptions behind the figures changed - hence the vertical line.
I can only add the line if I make the x axis "continuous" and then the x axis ignores the format monthname(date).
I suppose I could do it by doing an overlay but is there a simpler way???
Go to Solution.
It's because the expression that you're using is a date but the dimension that you're using is a month. If you also wrap your expression for the vertical line in MonthName(), it appears on the chart.
ah ... monthname(date(42950))
I still get a problem though when I try to show the x axis as a month - I need to show it as "continuous" and then it defaults to a number rather than the formatted axis my dimension is:
monthname (date(AppointmentDate)) or monthname (AppointmentDate) - neither work
Ahh... so when I make it continuous - the date then appears in NUMBER tab and there i can change the format to be MMM/yyyy