Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
awp2020
Contributor III
Contributor III

Waterfall and yield calculation

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 :

awp2020_0-1649313905267.png

 

 

 

And I do the calculations below :

awp2020_1-1649313905271.png

 

 

Below are the formulas:

awp2020_2-1649313905254.png

 

In the end I have this data:

awp2020_3-1649313905238.png

 

 

the values are the sum of the above calculations.

 

 

And this graph :

awp2020_4-1649313905248.png

 

 

Anyone to help me ?

Thank for your help

1 Solution

Accepted Solutions
awp2020
Contributor III
Contributor III
Author

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.

 

View solution in original post

1 Reply
awp2020
Contributor III
Contributor III
Author

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.