topic Re: interval function? in QlikView

interval function?

Fri, 10 Oct 2014 09:36:24 GMT

what is interval function work i am not talking about interval match

Re: interval function?

alexandros17 — Fri, 10 Oct 2014 09:39:08 GMT

Take a look in the help, it seems clear, otherwise give me an example of what is not clear

Re: interval function?

PrashantSangle — Fri, 10 Oct 2014 09:42:03 GMT

Hi,

The interval function formats the expression as a time interval according to the string given

as a format-code. If the format code is omitted, the

time format set in the operating system is used. Intervals may be formatted as a

time, as days or as a combination of days, hours, minutes, seconds and fractions

of seconds.

Syntax:

Interval(expression[,Format Code])

Example:

interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00

returns:

String:365 09:00

Number : 365.375

interval( A ) where A=1.375

returns:

String:09:00:00

Number : 0.375

Regards

Re: interval function?

senpradip007 — Fri, 10 Oct 2014 09:42:42 GMT

The interval function formats the expression as a time interval according to the string given as a format-code. If the format code is omitted, the time format set in the operating system is used. Intervals may be formatted as a time, as days or as a combination of days, hours, minutes, seconds and fractions of seconds.

interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00 returns 365 09:00

Re: interval function?

Fri, 10 Oct 2014 09:52:07 GMT

if u convert A into string u will get 365?

incase b is also near to same right?

can u give clear explination i am confused resulting output but i understood work of interval