Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Go to Solution.
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.