topic Re: Sum with Max Function throwing Error in QlikView

Sum with Max Function throwing Error

Thu, 24 Oct 2013 09:55:24 GMT

Hi All,

I am stuck with an expression:

My reqmnt:

I calculated the datediff between two dates for an user: Interval(Max(RespondTime)-JoinDt,'d')

I want to calculate the average date diff for all users:

When i try something like this its throwing an error:

sum( Interval(Max(RespondTime)-JoinDt,'d'))/Count(UserId)

Any help??

Re: Sum with Max Function throwing Error

Jason_Michaelides — Thu, 24 Oct 2013 10:00:50 GMT

Interval() is just a formatting function, I believe. Also, the expression you need will vary depending if it is in a chart or not and what the dimensions are.

What exactly are you trying to achieve?

Re: Sum with Max Function throwing Error

Thu, 24 Oct 2013 10:07:43 GMT

interval() function i believe it calculates the datediff between two dates.

and i am using the above expression in a chart(table) with no dimensions)

Re: Sum with Max Function throwing Error

Jason_Michaelides — Thu, 24 Oct 2013 10:11:26 GMT

No dimensions? So you just want a single number returned that is the average of Max(RespondTime)-JoinDt, across all users? Max(RespondTime) is no the global Max() but a per-user Max()?

I this is your requirement then you will need to use Aggr().

Is this what you want to achieve?

Re: Sum with Max Function throwing Error

jagan — Thu, 24 Oct 2013 10:14:35 GMT

Hi,

I think JoinDt is a dimension and having multiple values. If so, try getting the single value by using max() or min(). That's why you are getting an error.

If possible attach a sample file.

Regards,

Jagan.

Re: Sum with Max Function throwing Error

Thu, 24 Oct 2013 10:16:15 GMT

Exactly Jason.

Can you please send me the expression with Aggr fucntion.I tried but its not wrkn.

Re: Sum with Max Function throwing Error

Jason_Michaelides — Thu, 24 Oct 2013 10:26:55 GMT

Try this:

Avg(Aggr((Max(RespondTime)-JoinDt),UserID))

Re: Sum with Max Function throwing Error

Jason_Michaelides — Thu, 24 Oct 2013 10:28:11 GMT

And put it in a text object rather than a chart. Oh, and you can wrap it in Interval() I think to get it formatted in minutes:

Interval(Avg(Aggr((Max(RespondTime)-JoinDt),UserID)))

Hope this helps,

Jason

Re: Sum with Max Function throwing Error

Thu, 24 Oct 2013 11:50:39 GMT

Thanks Jason !! It worked!!