Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
abhaysingh
Valued Contributor II

ExpressionHelp

Hey Guys,

I have one Field in which i am getting Value in Below Format

Field1                                   Field2                                             Output(Wants in Second)

28-09-15 04:46:52 PM                28-09-15 01:15:20 PM                    3:31:31 PM  (How i can convert it into seconds)                           

Please Suggest

Thanks

Abhay

6 Replies
MVP & Luminary
MVP & Luminary

Re: ExpressionHelp

Try interval(Field1-Field2, 's')


talk is cheap, supply exceeds demand
abhaysingh
Valued Contributor II

Re: ExpressionHelp

No change in data..still getting  3:31:31 PM

abhaysingh
Valued Contributor II

Re: ExpressionHelp

Sory getting this number output

-15020907

thanks

MVP
MVP

Re: ExpressionHelp

This is a duplicate of Exp Help

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: ExpressionHelp

is the time that is stored contain seconds?  If seconds are not part of the field you will not be able to get accurate seconds (I do not believe)

pratap6699
Contributor

Re: ExpressionHelp

=Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 's')

to convert sec's as well as minuts and hours and days also by using interval function