Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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-1721204796093.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-1721205058680.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