Sales for Max Elapse

Mon, 16 Dec 2013 15:27:40 GMT

Hi,

Can you help me please to find the error in this expression :

=Max({1} Aggr(sum({$<[Due Year] ={">=$(=(max([Due Year])-($(V_YearBack)))) <=$(=(max([Due Year]) ))"},
Elapse={"<=$(=(Elapse))"}>}
Sales_$(V_Currency)), Elapse,

[Due Year],

[Due Month]))/1000

this expression returns the result below :

Due Year

Due Month

Elapse

Backlog

58,558

2011

-36

29,721

2012

-50

11,706

2012

-43

22,119

2012

-36

33,758

2012

-29

46,705

2012

-22

47,495

2012

-15

49,322

2012

-8

49,926

2013

-50

9,983

2013

-43

21,439

2013

-36

33,712

2013

-29

45,932

2013

-22

54,289

2013

-15

57,664

2013

-8

58,558

What i want to see is sales for the Max Elapse ?

Thanks for your help

topic Sales for Max Elapse in QlikView

Sales for Max Elapse