Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
In the script, your timestamp format should be set accordingly:
SET TimestampFormat = 'M/D/YYYY hh:mm:ss';
Then you can load your values just use interval():
=interval( [End Date]-[Start Date],'ss')
or if you want to do further calculcation in units seconds:
=num#(interval( [End Date]-[Start Date],'ss'))