Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mikecherry
Contributor III
Contributor III

Return a specific Break Even Date from Table

Hi guys,

 

I am trying to calculate break even in a chart and I want to return just the first value when my Column A > Column B.

if(if(Rangesum(above($(vRDERDist),0,rowno()))>Rangesum(above($(vRDERCost),0,rowno())),1,0)=1,Date(min(Data_PeriodEnd)),null())

 This is the expression I have in the chart at the moment that gives me every date if Column A > Column B.

How do I change the formula if I want to return the first data where Column A > Column B ?

 

Capture Break.PNG

Labels (3)
10 Replies
erikbalunis
Contributor
Contributor

Although I don't completely understand the formula, I recognized a critical difference between the sample/example data and my data. The sample/example "costs" were positive values and my costs were negative values. In creating a new variable that negated my cost values, the calculation returned the expected values