topic Interval value into number in QlikView

Interval value into number

manojkulkarni — Thu, 17 Mar 2016 06:02:09 GMT

Hi Friends,

I am using interval function to calculate difference of 2 dates & getting difference values in minutes. I need to use this value to calculate % of total minutes in month. eg: my derived values in 768 minutes and total minutes available is 41760. % is 1.8%. but i am getting a different value all together which is .0013%.

When I convert the above value 768 to number using num() function, it returns me .0056.. something.

Why can't we use 768 value directly ?

Re: Interval value into number

Gysbert_Wassenaar — Thu, 17 Mar 2016 06:51:50 GMT

The unit of times and dates is days. The interval function still returns a value with a unit of days. If you format the result of the difference between two dates in minutes you only change the display format. The real value is still in days. There are 1440 minutes in a day so if you want to use 768 directly then you have to multiply it by 1440.

Re: Interval value into number

Kushal_Chawda — Thu, 17 Mar 2016 07:20:44 GMT

Try this

time(frac(round(Date1,(1/24*60))) - frac(round(Date2,(1/24*60))),'mm')

Re: Interval value into number

manojkulkarni — Thu, 17 Mar 2016 08:34:29 GMT

thanks Gysbert Wassenaar,

it worked.