Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mellerbeck
Creator II
Creator II

Reference Line on Y Axis when using time

I have a chart that has Times on the Y Axis created with an time(floor(ADate, 1/24),'hh TT') as Chart_Time expression

for example

6 AM

7 AM

8 AM

I am trying to add a vertical reference line on 7 AM

I've tried

=7

='7'

='7 AM'

=time('07 AM','hh TT')

and haven't hit on it, any thoughts?

13 Replies
johnw
Champion III
Champion III

I think either of these would work:

=timestamp#('9/9/2011 9:01:00 AM','D/M/YYYY h:mm:ss TT')

=makedate(2011,9,9)+maketime(9,1)

mellerbeck
Creator II
Creator II
Author

Hmm, tried both (I appreciate all the help greatly BTW) but still no joy

Wonder what's breaking it.

johnw
Champion III
Champion III

Did you put it on the Y-axis instead of X-axis?  To put a reference line on the X-axis, you need to select "continuous" for the dimension.  Use the number tab to fix the formatting.  An X-axis reference line defined with either of the expressions above then works just fine for me.

mellerbeck
Creator II
Creator II
Author

Great! That was it!