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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
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