topic Re: Variable expression for average time in QlikView

Variable expression for average time

Wed, 24 Jun 2015 12:41:43 GMT

Hello Guys,

I am trying to create a variable with the below expression:

=interval(Avg({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'}>}conv)/24, 'hh:mm:ss')

The conv is the conversation time but unfortunately there is something wrong with the formula.

When i do the expression as below i get the answer in numeric but I need it in time 'hh:mm:ss'

=Avg({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'}>}conv)

Any suggestions.

Thanks,

Hasvine

sunny_talwar — Wed, 24 Jun 2015 12:47:59 GMT

Why do you need to divide your expression with 24? What number do you get when you don't use interval function?

Wed, 24 Jun 2015 12:52:33 GMT

The answer i get is 0,001787003

Wed, 24 Jun 2015 12:53:37 GMT

I tried removing the /24 and its working great.

Thanks

sunny_talwar — Wed, 24 Jun 2015 12:55:04 GMT

If the output you are expected it 00:02:34 then try this:

=Interval('0.001787003', 'hh:mm:ss') or without 24

=interval(Avg({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'}>}conv), 'hh:mm:ss')

sunny_talwar — Wed, 24 Jun 2015 12:55:21 GMT

Awesome

Thu, 25 Jun 2015 05:07:28 GMT

Thanks for your help.