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: 
Not applicable

Kpi problem - need help to find correct formula

Hi Everybody,

I am facing some problem getting the KPI I want.I need to find the correct formula to get the following KPI:

What is the area with an average yield above 90 ?

Here is my data sample:

8fed0c28d34c4f959d4177408f838ef0.png

By sorting with the highest yield on the top in a table, and then calculating the cumul yield and area, I find easily the correct answer, which is in this case 124.6.


Does anyone know how to get this value directly in a KPI ?


Thank you for your help,

Regards,

Tanguy

10 Replies
Not applicable
Author

I does not work, when I add some data, there is no change