Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist 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
Gysbert_Wassenaar

Try interval(Field1-Field2, 's')


talk is cheap, supply exceeds demand
abhaysingh
Specialist II
Specialist II
Author

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

abhaysingh
Specialist II
Specialist II
Author

Sory getting this number output

-15020907

thanks

jonathandienst
Partner - Champion III
Partner - Champion III

This is a duplicate of Exp Help

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

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
Creator
Creator

=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