Showing today on a chart

[Dayna]

Hello All,

This might sound silly, but I want to make it obvious on a bar or line chart where today is. I have multiple dimensions and expressions, and one of the dimensions will be date or week/year.

I was thinking of doing an IF statement on the colour to change for today(), but then the legend gets screwed up..

Any ideas? I just want to make it obvious to the users where the current date is on the chart!

Kind Regards,
Dayna

[Dayna]

It might be an option, but doesn't work for me.. can you try on your sample?

Kind Regards,
Dayna

[lironbaram]

hey attach

is my suggestion

adding an expression which Write Today Above the correcet date

[Anonymous · Accepted solution]

Hi Dayna,

Maybe this is what you are looking for?

Check file.

[Dayna]

Hello Dennis,

That's exactly what I was after! Thank you!!

[Dayna]

Dennis, how did you do it? lol!

[Anonymous]

Hi Dayna,

I used the "Reference Lines" option in the presentation tab

If you open my document and you go there you will see "today", select this and click "Edit", you will see the expression and the options I used to make this line:

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

Because my grahp has months it has to return the right month and the amount of day (from the current month) devided by the total days of the current month.

So for today (feb 10) it will return 2 (=month) , 10/28 (day 10 of 28) = 2,35714

I hope you can use this and adjust it to your needs.

[Dayna]

Hello Dennis,

Many thanks for the above, I have only one last question... Continuous X is greyed out for me, how did you get this option?

Kind Regards,
Dayna

[Anonymous]

I found:

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.

Here: http://community.qlik.com/forums/t/28348.aspx