Waterfall and yield calculation

[awp2020]

Hello,

Please open XL file to see my request. 

I need to do different yield effect calculations and display them with a waterfall chart.

For this I made an example in Excel. But I would like to perform these calculations under Qlik sense. 

The periods are not necessarily concurrent for the calculations

I have this input table :

And I do the calculations below :

Below are the formulas:

In the end I have this data:

the values are the sum of the above calculations.

And this graph :

Anyone to help me ?

Thank for your help

[awp2020 · Accepted solution]

Hello,

I found myself.

The problem was to find the selected dates in the filter pane. I posted the solution in other request.

when you have the dates you can do the calculations with set analysis.