Ignore Time selection in aggr function

[#1]

Hi,

A bit of a brain freeze over here.

I need the below expression to ignore the time selection. Where do i put the

{ $ <Time60 = > }   or similar?

SUM(Aggr(IF(SettlementOrder= (MIN(TOTAL <Date>  SettlementOrder)), Sum(Balance)), Date, SettlementOrder)) 

Thanks in advance,

Olle

[JonnyPoole]

Put it in ALL chart aggregation functions  (in this case sum() and min()  ) . Assuming all other syntax is accurate...

change:

SUM(Aggr(IF(SettlementOrder= (MIN(TOTAL <Date>  SettlementOrder)), Sum(Balance)), Date, SettlementOrder))

to:

SUM(  { $ <Time60 = > }  Aggr(IF(SettlementOrder= (MIN( { $ <Time60 = > } TOTAL <Date>  SettlementOrder)), Sum( { $ <Time60 = > } Balance)), Date, SettlementOrder))

[#3]

Hi Jonathan,

yes the original works fine.

I tried your tweak but only receiving zero-values

Kind Regardfs,

Olle

[MK_QSL]

Provide your sample data or apps

[JonnyPoole]

If you can't share the QVW i would try breaking apart the expression and putting those parts in new expressions. 

Start with these:

MIN( { $ <Time60 = > } TOTAL <Date>  SettlementOrder))

Sum( { $ <Time60 = > } Balance)

and then add start to wrap in the rest of it...

IF(SettlementOrder= (MIN( { $ <Time60 = > } TOTAL <Date>  SettlementOrder)), Sum( { $ <Time60 = > } Balance))

post which part is failing...

[#6]

Solved my problem using the FirstSortedValue function instead, but thanks for your help!

Kind REgards,

Olle

[#7]

Actually the two of them works perfect when used separately.

But when I put them together I receive null values.

[JonnyPoole]

hi -  i wasn't 100% sure on the feedback.  I think you mentioned that both the Sum() and the Min( TOTAL <Date> ) work as seperate expressions with the SET ANALYSIS statement but no when you do the If ().

If that is the case you could try wrapping SettlementOrder in the Only() function and putting the SET statement in there too... but i'm not 100% it will work.  Really need to see a sample QVW

IF(  Only({ $ <Time60 = > }  SettlementOrder) = (MIN( { $ <Time60 = > } TOTAL <Date>  SettlementOrder)), Sum( { $ <Time60 = > } Balance))