topic Re: Interval in QlikView

Interval

dhavalvyas — Wed, 25 Nov 2020 16:16:04 GMT

What is concept of interval in qlikview ? can any one tell me with the help of example ?

Re: Interval

sarvesh — Sat, 18 Mar 2017 06:27:37 GMT

Hi..Dhaval,

Interval - script and chart function

Interval() formats a number as a time interval using the format in the system variables in the load script, or the operating system, or a format string, if supplied.

Intervals may be formatted as a time, as days or as a combination of days, hours, minutes, seconds and fractions of seconds.

Syntax:

Interval(number[, format])

Return data type: dual

Arguments:

Argument	Description
number	The number to be formatted.
format	String describing how the resulting interval string is to be formatted. If omitted, the short date format, time format, and decimal separator set in the operating system are used.

Examples and results:

The examples below assume the following default settings:

Date format setting 1: YY-MM-DD
Date format setting 2: hh:mm:ss
Number decimal separator: .

Example	String	Number
Interval( A ) where A=0.375	09:00:00	0.375
Interval( A ) where A=1.375	33:00:00	1.375
Interval( A, 'D hh:mm' ) where A=1.375	1 09:00	1.375
Interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00	365 09:00	365.375

Re: Interval

ecolomer — Sat, 18 Mar 2017 06:44:32 GMT

See this:

Interval Match Feature/Function

IntervalMatch para Asignar Escala

Re: Interval

Anonymous — Sat, 18 Mar 2017 06:53:34 GMT

One of the use of interval is to calculate between 2 days

I prepare a Sample for u ,to understand what I say

Re: Interval

Frank_Hartmann — Sat, 18 Mar 2017 08:27:17 GMT

Also have a look into class function if you need to assign an expression to an interval!

hope this helps

Re: Interval

sarvesh — Sat, 18 Mar 2017 10:44:18 GMT

Please mark "Helpful" and "Correct" to close this thread, if your doubt has been cleared.

Regard's

Sarvesh Srivastava