topic Re: chart experssion time duration in QlikView

chart experssion time duration

srinivasa1 — Mon, 29 Oct 2012 18:05:40 GMT

Howi can take time duration between start date(10/1/2012 1:00:00 PM) and end date(10/1/2012 3:00:00 PM)

in chart experssion

thanks

swuehl — Mon, 29 Oct 2012 18:13:24 GMT

Look into interval() function in QV.

=interval(TIMESTAMP2 - TIMESTAMP1)

Your timestamps should be interpreted as such, use timestamp#() function if needed, with an appropriate format code.

srinivasa1 — Mon, 29 Oct 2012 18:48:24 GMT

It helped me Thanks sir.

srinivasa1 — Mon, 29 Oct 2012 19:02:48 GMT

Thanks for your reply .How i can avoid AM and PM ist come along with duration like (1.00.00 AM) i need 1 hr or 1.30 hr like that

thanks

MayilVahanan — Mon, 29 Oct 2012 19:04:34 GMT

Try like this

=interval(TIMESTAMP2 - TIMESTAMP1,'hh:mm')

Hope it helps

srinivasa1 — Mon, 29 Oct 2012 19:20:34 GMT

Thanks .its correct Ans.but i have set number style as interval its also working.thanks for your guidence.