Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

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.

Community Browser