topic Re: How to average an expression column? in QlikView

How to average an expression column?

Mon, 26 Jan 2026 16:26:21 GMT

Hi,

my straight table consist of 2 columns: TIME as dimension, expression: [TIME]-above[TIME] to get the interval between each row.

for example:

time interval

00:01:00 00:00:00

00:02:30 00:01:30

etc..

i am looking for a solution to be able to average the Interval column, i have tried by adding expression: avg(interval), but i get in each row of this 3rd column: '-'.

can someone assist?

thanks.

Moti

Re: How to average an expression column?

srchilukoori — Mon, 30 Sep 2013 19:10:13 GMT

check the attached qvw.

Under the expressions tab of the straight table properties, in the totals section.

Re: How to average an expression column?

israrkhan — Mon, 30 Sep 2013 19:10:49 GMT

try =avg(column(3)), if it is third column.

Re: How to average an expression column?

Mon, 30 Sep 2013 19:18:25 GMT

thanks, IsrarKhan,

i have tried this but didnt work. got '-' in each row of this expression.

Re: How to average an expression column?

srchilukoori — Mon, 30 Sep 2013 19:27:54 GMT

did you see my app from my previous post.

Is this what you are trying to implement?

Re: How to average an expression column?

Mon, 30 Sep 2013 19:29:36 GMT

yes

Re: How to average an expression column?

Anonymous — Mon, 30 Sep 2013 19:33:01 GMT

Hi Moti,

I do not know if I got it right, but to have the avg of the interval, use:

Time(( RangeSum( Above( Sum( Time ), 1, RowNo() ) ) + Time ) / RowNo(), 'hh:mm:ss' )

See Attached.

Regards

Re: How to average an expression column?

Mon, 30 Sep 2013 19:34:44 GMT

thanks, but i can not see any attached nor send my qvd

Re: How to average an expression column?

Anonymous — Mon, 30 Sep 2013 19:42:51 GMT

Well, basically there are 2 averages:

With the current row included:

Time(( RangeSum( Above( Sum( Time ), 1, RowNo() ) ) + Time ) / RowNo(), 'hh:mm:ss' )

Without the current row included:

Time(( RangeSum( Above( Sum( Time ), 1, (RowNo()-1) ) ) ) / ( RowNo() - 1 ) , 'hh:mm:ss' )

Re: How to average an expression column?

Mon, 30 Sep 2013 19:45:56 GMT

thanks. didnt think of this approach.