topic Time field on Bar or Scatter Chart Help!!! in QlikView

Time field on Bar or Scatter Chart Help!!!

vishsaggi — Fri, 08 May 2015 12:35:24 GMT

Hello Experts,

I have a load statement I want to plot a bar or a scatter chart for the time with a time scale

between 6Am, 7Am,8Am,9Am etc...

Load * Inline [

Task1, StartedAt

abc1,6:01:00

abc2,6:01:00

abc3,6:13:17

abc4,6:33:25

abc5,7:00:00

abc6,7:00:00

abc7,7:00:00

abc8,7:00:00

abc9,7:20:00

abc10,7:00:00

abc11,7:00:00

abc12,7:10:00

abc13,7:00:00

abc14,7:14:00

abc15,7:15:01

abc16,7:19:27

abc17,7:20:07

abc18,7:30:00

abc19,7:35:00

abc20,7:40:27

abc21,7:41:30

abc22,7:50:00

abc23,7:50:00

abc24,7:50:00

];

Regards,

Re: Time field on Bar or Scatter Chart Help!!!

Anonymous — Fri, 08 May 2015 12:47:10 GMT

Would an expression like this help :

=time(round(time#('6:01:00','h:mm:ss'),1/24),'htt')

or with your field name

=time(round(time#(StartedAt,'h:mm:ss'),1/24),'htt')

Re: Time field on Bar or Scatter Chart Help!!!

vishsaggi — Fri, 08 May 2015 12:52:28 GMT

Thanks Bill for the prompt reply but I want the chart to be like Task Field in Yaxis and Time scale on X axis and the startedAt field in the Chart like scatter, Hope you got me.

Re: Time field on Bar or Scatter Chart Help!!!

vishsaggi — Fri, 08 May 2015 15:53:46 GMT

used the grid chart its good now.