Interval

[dhavalvyas]

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

[sarvesh]

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

[ecolomer]

See this:

Interval Match Feature/Function

IntervalMatch para Asignar Escala

[Anonymous]

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

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

[Frank_Hartmann]

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

hope this helps

[sarvesh]

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

Regard's

Sarvesh Srivastava