topic Re: Add a Reference Line for Todays Date in QlikView

Add a Reference Line for Todays Date

denwo2010 — Mon, 14 Nov 2011 11:09:09 GMT

Hi,

I want to add a Reference Line for todays date on the attached chart, but for some reason it is not setting this?

Thanks

SunilChauhan — Mon, 14 Nov 2011 11:34:51 GMT

see the attached file

hope this helps

denwo2010 — Mon, 14 Nov 2011 11:54:58 GMT

Hi,

I want the line to appear vertical.

Thanks

Anonymous — Mon, 14 Nov 2011 12:11:32 GMT

I think this is what you need:

=Month(today()) + Day(today()) / Day(MonthEnd(today()))

Take a look at the attechment and let me know if it works for you ok?

Good luck,

Dennis.

Anonymous — Mon, 14 Nov 2011 12:17:48 GMT

Extra information:

Continuous X requires that you have a numeric value on the X-axis and have chosen to display it as continuous on the axis tab.

denwo2010 — Mon, 14 Nov 2011 12:27:29 GMT

Hi Dennis,

So I take it is not possible to do with the graph that I have now as I do not have numeric values on thex axis?

Thanks

Anonymous — Mon, 14 Nov 2011 12:35:52 GMT

Not like this no. Your X-axis needs to be numberic because it need to count/calculate where the line should show up.

Can't you make your dimension numeric?

denwo2010 — Mon, 14 Nov 2011 13:22:57 GMT

OK Thanks Dennis