Selecting Date Range on Line Chart

[bskemp01]

I have a line chart that looks like this:

as you can see on Feb-6th the REV YTD has a value of $37,240,518.54. When i select a date range that includes this, see what happens below:

as you can see the value for Feb-6th is now $18,368,908.11. I need a way to select date ranges like this where my accumulation stays constant and shows the first value. is this possible in qlik?

here is my expression for REV YTD:

{$<
  Year={'$(=max([Year]))'},
  [DateType]={'Invoiced'}
>}

RangeSum(
  Above(
    Sum([Company 1 Sales])
    +
    Sum((1/[Rate])*[Company 2 Sales CAD])
    +
    Sum([Company 3 Sales])
    +
    Sum((1/[Rate])*[Company 4 Sales CAD])
    ,0,RowNo(total)
  )
)

[Digvijay_Singh · Accepted solution]

Probably you need to implement as of table instead of above function, check if that link helps - 

https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130