Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

calculate an input value that is between the latest date

I have Field 

Sxbbb_0-1721207055457.png

 

I want to calculate an input value that is between the latest date of Date_Start_FX and the latest date of KCE_DATE.

 

I try  Sum(Aggr(if(KCE_DATE >= Date(Max(Aggr(Max(Date_Start), FX_FixtureID))),
Sum(if ((INPUT ) >0 ,INPUT , [INTERNAL_REWORK])),0),FX_FixtureID)) 

 

Sxbbb_1-1721207055445.png

 

I want to calculate an input value that is between the latest date of Date_Start_FX and the latest date of KCE_DATE.

1 Reply