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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Flint89
Contributor
Contributor

Min date after date from different dimensions

I am trying to calculate the 'LT Hour' lifetime of a part. 

To do this, I am taking the most recent LT Hour value which is in the same table as the LifeLoggingDate and then subtracting the oldest LT Hour value, but only when it exceeds the date in which the part was installed (this information is in a different table to the lifelogging). 

The below formula works when I select a PartSN in the table. 

aggr(Max({<LifeLoggingDate={"=aggr(max(LifeLoggingDate),DeviceID)"}>}LTHours),PartSN,DeviceID)
-
aggr(Min({<LifeLoggingDate={"=aggr(min(LifeLoggingDate),DeviceID)"},LifeLoggingDate={">$(=(Install_Date))"}>}LTHours),PartSN,DeviceID)

 

My intention is to see all Part SN and be able to sort by the LTHours to assess part lifetime.  Any suggestions?

0 Replies