topic Re: Timestamp on Y Axis? in QlikView

Timestamp on Y Axis?

MalcolmCICWF — Mon, 29 Jun 2015 21:45:28 GMT

So I may be over complicating this, but I have a bar chart that I can't figure out just how to get my timestamp (ex 8:35 AM) on the Y Axis while having the day of the month on the X axis.

I have as a dimension a "Job name", each has a specific end time. I wan to be able to select the Job Name and see on the bar chart at which time it finished each day. Can I just display the time in the expression some how, or do I have to have an aggregation function in the expression?

The attached is a screen shot of my chart, but the Y axis is incorrect because I did a sum of a hh:mm TT format...

Re: Timestamp on Y Axis?

MarcoWedel — Mon, 29 Jun 2015 22:13:41 GMT

If there is only one value per day you might not need an aggregation at all.

The reason for the values on your expression axis starting at 1900 could be the "forced 0" check box in the axes tab showing your timestamp starting from 0 (=year 1900).

Try to uncheck it.

As you mentioned, you want to show time values, you might have to extract the time part from your timestamp using

Time(Frac(YourTimestamp))

in your expression as well. ("forced 0" then could remain checked).

hope this helps

regards

Marco

Re: Timestamp on Y Axis?

swuehl — Mon, 29 Jun 2015 22:19:03 GMT

If there is only one value per day, you can use

=only(EndTimeField)

If there are more than one value per day, you'll need to decide what you want to show, maybe the average time?

=avg(EndTimeField)

It looks to me that your current field is indeed a timestamp field, containing date and time.

Use frac() to get only the time part:

=only(frac(EndTimeField))

=avg(frac(EndTimeField))

Then format your expression results on number tab as time or interval.

Re: Timestamp on Y Axis?

MalcolmCICWF — Tue, 30 Jun 2015 16:39:29 GMT

Thanks, I was not aware of the Only function

Re: Timestamp on Y Axis?

swuehl — Tue, 30 Jun 2015 16:53:37 GMT

The Only Function