topic Re: Nested Aggregation in QlikView

Nested Aggregation

Fri, 14 Aug 2015 16:31:59 GMT

Hello Everyone,

I have calculated a duration using this formula :

Interval(Min({$<Location-={'X'}>}InnerTMSTP) - Min({$}InnerTMSTP), 'm')

This gives me a Nu,ber which corresponds to the duration in minutes.

I wanted to sum all the duration for my different references but when I wrote :

Sum(Interval(Min({$<Location-={'A99***'}>}InnerTMSTP) - Min({$}InnerTMSTP), 'm') )

The software tells me I have an error due to nested aggregation.

Do you know what is that about ?

swuehl — Fri, 14 Aug 2015 16:35:32 GMT

Try

=Interval(

Sum ( Aggr( Min({$<Location-={'A99***'}>}InnerTMSTP) - Min({$} InnerTMSTP), YourReferencesField ))

, 'm')

marcus_sommer — Fri, 14 Aug 2015 16:37:07 GMT

You need to wrap your expression in an aggr() maybe something like this:

Sum(aggr(Interval(Min({$<Location-={'A99***'}>}InnerTMSTP) - Min({$}InnerTMSTP), 'm'), Dimensions))

- Marcus

MK_QSL — Fri, 14 Aug 2015 16:42:44 GMT

SUM(Aggr(Interval(Min({$<Location-={'X'}>}InnerTMSTP) - Min({$}InnerTMSTP), 'm'),Ref))