Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Working out the average time for a specific code

I have a table that looks like this:

pic.png

What I want to do is add another column that shows the average number of minutes spent for all calls for the problem code that the call is linked to. Can anyone suggest how I would go about working it out? I'm not sure how I would write an expression to capture the sum of minutes spent for the specific problem code.

1 Solution

Accepted Solutions
jason_michaelid
Honored Contributor II

Re: Working out the average time for a specific code

Add an expression:

Avg(TOTAL <[Problem Code]> [Minutes Spent])

Hope this helps,

Jason

3 Replies
jason_michaelid
Honored Contributor II

Re: Working out the average time for a specific code

Add an expression:

Avg(TOTAL <[Problem Code]> [Minutes Spent])

Hope this helps,

Jason

Not applicable

Re: Working out the average time for a specific code

Awesome - thanks a lot. Qlikview is pretty amazing.

jason_michaelid
Honored Contributor II

Re: Working out the average time for a specific code

That it is

Community Browser