AVG Interval Set Analysis

MauriceLudo — Wed, 29 Mar 2017 11:06:18 GMT

Hi,
I would like to know why this expression does not refer to the same result? There is a difference of 2 min

avg(interval(([Date clôture] )- ([Créé le]),'hh:mm:ss') )

avg( {< [Canal d'entrée]={'Courrier'} >}Interval([Date clôture],'hh:mm:ss')) - avg( {< [Canal d'entrée]={'Courrier'} >}Interval([Créé le],'hh:mm:ss'))

Best regards

Maurice

Re: AVG Interval Set Analysis

marcus_sommer — Wed, 29 Mar 2017 11:34:09 GMT

Your first expression contained no condition but the second does: {< [Canal d'entrée]={'Courrier'} >} - whereby I assume you had applied the condition to the first per selection.

But there is another difference between them. The first calculates the average of the time-differences on row-level and the second returned the differences of the average of each single time-field or with other terms it's the subtraction of two aggregations.

- Marcus

topic AVG Interval Set Analysis in QlikView

AVG Interval Set Analysis

Re: AVG Interval Set Analysis