Sum where one date field is greater than second date field used as dimension

[Anonymous]

Hi, I have two tables, one has a date field (OperatingDate) and a value associated with each date (Sales).  The second is a calendar with daily date field (Date).  I'd like to create a table with Date as the dimension, and the sum of all Sales where OperatingDate is >= the Date value in that row.  Tried to put an illustration of what I'm looking for below, any help would be appreciated!

OperatingDate	Sales
8/4/2017	10
8/5/2017	20
8/6/2017	15
8/10/2017	5

Date
8/4/2017
8/5/2017
8/6/2017

Date	Sum(Sales)
8/4/2017	50
8/5/2017	40
8/6/2017	20

[sunny_talwar · Accepted solution]

May be this

=Sum(If(Date <= OperatingDate, Sales))

[Anonymous]

That worked, thank you!

[sunny_talwar]

Awesome, please close the thread by marking the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny