topic Reference Line on Y Axis when using time in QlikView

Reference Line on Y Axis when using time

mellerbeck — Thu, 01 Sep 2011 18:01:05 GMT

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 AM'

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

and haven't hit on it, any thoughts?

Re: Reference Line on Y Axis when using time

sbaldwin — Tue, 06 Sep 2011 14:53:48 GMT

Hi, have you tried in the axis tab of your chart props change the dimension axis to continus, then you can add a reference line (there is a radio button to allow this after you click add.)

Thanks

Steve

Reference Line on Y Axis when using time

IAMDV — Tue, 06 Sep 2011 15:03:45 GMT

Please can you post the sample QV document? Possible?

Cheers - DV

Re: Reference Line on Y Axis when using time

sbaldwin — Tue, 06 Sep 2011 15:19:22 GMT

something like this?

Reference Line on Y Axis when using time

swuehl — Tue, 06 Sep 2011 15:26:08 GMT

I believe that time is represented by the decimal places in numerical representation.

Have you tried

=7 / 24

as expression to represent 7 am?

Regards,

Stefan

Re: Reference Line on Y Axis when using time

mellerbeck — Fri, 09 Sep 2011 17:54:01 GMT

Thanks all, still struggling with this. I attempted swuehl suggestion but not joy attached is an example of the chart I am trying to add the vertical time line at 7 AM

Re: Reference Line on Y Axis when using time

mellerbeck — Fri, 09 Sep 2011 17:54:57 GMT

Thanks sbaldwin, very close but the dimension is actually in time format

Re: Reference Line on Y Axis when using time

mellerbeck — Fri, 09 Sep 2011 17:55:21 GMT

See my reply below, I attached a sample.

Reference Line on Y Axis when using time

johnw — Fri, 09 Sep 2011 19:42:10 GMT

Chart_Time isn't a time, it's a timestamp. You don't display the date, but it's still there. If you want to keep the date, I highly recommend displaying it to avoid the exact kind of confusion you just went through. However, then asking for a reference line at 7:00 AM makes no sense to me because on which DATE do you want that line? All of them? The first one?

If you don't want the date in your time, then strip it out using something like frac(). Then if you use a continuous axis, something like the suggested 7/24 or your time('07 AM','hh TT') should work fine.

Re: Reference Line on Y Axis when using time

mellerbeck — Fri, 09 Sep 2011 20:46:27 GMT

Thanks John! That is making a lot more sense now! Assuming I wanted to make a reference line on the date and time how would I do that?

I tried changing chart_time to be

timestamp(floor(Trsx_CreationDate, 1/24)) as Chart_Time

And then adding a refernce line with

='9/9/2011 9:00:00 AM'

=Timestamp('9/9/2011 9:01:00 AM')

But so far no Joy.

Re: Reference Line on Y Axis when using time

johnw — Fri, 09 Sep 2011 20:49:41 GMT

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)

Re: Reference Line on Y Axis when using time

mellerbeck — Fri, 09 Sep 2011 20:56:25 GMT

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

Wonder what's breaking it.

Re: Reference Line on Y Axis when using time

johnw — Fri, 09 Sep 2011 21:02:20 GMT

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.

Re: Reference Line on Y Axis when using time

mellerbeck — Fri, 09 Sep 2011 21:13:53 GMT

Great! That was it!