Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

phill_gilchrist
New Contributor III

AVG() Not Returning Expected Results

I have a straight chart, with call numbers and turnaround times.

I'm trying to calculate the average, with a straight - avg() and it's producing a strange result.

I've tried sum(total turnaround) / count(distinct call no) - same result.

Bit stumped now.

Any help greatly appreciated.

File attached.

Tags (1)
1 Solution

Accepted Solutions
jsn
Honored Contributor

Re: AVG() Not Returning Expected Results

When you say Strange Result.. do you mean a decimal value?

In that case, try using the function Time() or Interval() around your expression to format it as a time portion of a timestamp.

2 Replies
jsn
Honored Contributor

Re: AVG() Not Returning Expected Results

When you say Strange Result.. do you mean a decimal value?

In that case, try using the function Time() or Interval() around your expression to format it as a time portion of a timestamp.

phill_gilchrist
New Contributor III

Re: AVG() Not Returning Expected Results

Spot On.

Interval worked.

Thanks.

Community Browser