Skip to main content Skip to complementary content

Interval# - script and chart function

Interval#() evaluates a text expression as a time interval in the format set in the operating system, by default, or in the format specified in the second argument, if supplied.


Interval#(text[, format])

Return data type: dual


Argument Description

The text string to be evaluated.


String describing the expected input format to use when converting the string to a numeric interval.

If omitted, the short date format, time format, and decimal separator set in the operating system are used.

The interval# function converts a text time interval to a numeric equivalent.


The examples below assume the following operating system settings:

  • Short date format: YY-MM-DD
  • Time format: M/D/YY
  • Number decimal separator: .
Examples and results
Example Result
Interval#( A, 'D hh:mm' )
where A='1 09:00'

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: