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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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.

Labels (4)
1 Reply
Sxbbb
Creator III
Creator III
Author