Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

srinivasa1
Contributor

chart experssion time duration

Hi

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

1 Solution

Accepted Solutions

Re: chart experssion time duration

HI

Try like this

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

Hope it helps

5 Replies
MVP
MVP

Re: chart experssion time duration

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
Contributor

Re: chart experssion time duration

It helped me Thanks sir.

srinivasa1
Contributor

Re: chart experssion time duration

Hi

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

Re: chart experssion time duration

HI

Try like this

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

Hope it helps

Highlighted
srinivasa1
Contributor

Re: chart experssion time duration

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