Hour x-axis showing 00

prees959 — Mon, 25 Sep 2017 08:03:50 GMT

HI,

I am trying to chart the number of calls per hour on an bar chart. With the hour on the x-axis and the total calls on the y-axis. My expression to get the hour of the call is :

time(hour(time([Hours],'hh')),'hh')

The chart is counting the number of calls correctly but for each hour it is showing '00' ..

can anyone help please?

Phil

Re: Hour x-axis showing 00

swuehl — Mon, 25 Sep 2017 08:05:49 GMT

Just use

hour([Hours])

if your Hours field shows a timestamp. If not, clarify the format / content of that field.

topic Hour x-axis showing 00 in QlikView

Hour x-axis showing 00

Re: Hour x-axis showing 00