How to include data from day before

[joshrussin]

I am trying to create a formula that will be the equivalent of this.

Selected_Date - (Day_Before_WIP - Current_Processed)

Trying to display the data within this graph

This is what the table looks like.

[joshrussin]

The picture I sent was of a working file, but the values were created in excel. I am trying to get Qlik to do the work instead of manually doing the calculations in excel