Aggr function problem

inescastelhano — Fri, 19 Jun 2015 10:29:16 GMT

Hi guys,

I am having trouble with the following expression, because it is returning zero and it shouldn't:

=sum(aggr( (

(sum( { < myYear=,myMonth=,myDay=, [End Date]=$(=vDataSel_min),[myDate]=$(=vDateSel) > } [End Date] ) )

(min( {$} TOTAL

([myDate])))),[ID]))

My idea is to subtract the minimum of the selected date to the EndDate for each ID. Each ID has its own EndDate.

I have already the following similar expression and it is working fine:

=sum(aggr((

max({$} TOTAL

([myDate])+1)

)

- (sum({<myYear=,myMonth=,myDay=, [myDate]=$(=vDateSel),[End Date]=$(=vDataSel_max)>}

([myDate]))),[ID]))

I don't understand why it is working for the second one and it is not working for the first one. There are no errors in the defined variables, I am using all of them in other objects.

Thanks in advance,

Inês

topic Aggr function problem in QlikView

Aggr function problem