How to Calculate Duration when you have only one date time column

[Michael_Tarallo]

Learn how to simply calculate duration when you have only one date / time column.

[Michael_Tarallo]

In this video I quickly show you how to create a duration column using 1 single date / time column. This comes in handy when wanting to calculate differences in time period values stored in the same column. 

• Sample .QVF attached
• Qlik Help Reference: Previous()
• Telemetry app mention 

Calculate Duration.qvf

[hornstrup]

Great little tip

To expand a little - if you want this to be responsive (say you have multiple sensors and want the duration to be dynamic with selections in sensors), that would also be possible using the "Interval" and "Above" chart functions- an expression like:

Measure:
=interval(above(Total Timestamp#(Time,'MM/DD/YYYY hh:mm:ss'))-Timestamp#(Time,'MM/DD/YYYY hh:mm:ss'),'hh:mm:ss')

Just remember the "Total" in the "Above" function when there's more than one dimension. 

/Jan Hornstrup Andersen