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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn 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-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