topic Hours in axes in QlikView

Hours in axes

Wed, 05 Nov 2014 13:24:57 GMT

Hello,

I am writing to you because I would like to display ours in axes of a chart.

I get data from a database to the format "dd/mm/yyyy hh:mm:ss" and I convert it in the script in hours with :

Time(HM_ACTIONREAL) as [Action Time]

But in my chart, the total of time is good, but in axes I don't have a time format.

Do you know how can I do this ?

Thanks lot

Re: Hours in axes

Gysbert_Wassenaar — Wed, 05 Nov 2014 13:31:25 GMT

The Time function can only return a value between 0:00:00 and 23:59:59. If in your chart you sum hours then you should use the Interval function: interval(sum([Action Time]),'hh:mm:ss'). And you can change the number format on the Number tab. Check to option to override the expression default and choose the format you need and optionally change the format string as well.

Re: Hours in axes

Wed, 05 Nov 2014 13:50:22 GMT

Hi,

Thanks for your response.

Can I afford to show you my results ?

I change the definition here :

So I get this format :

I go to number tab and choose "Hour"

But finally I get this :

Do you think it's a problem concerning my data ?

Thank you again.