Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate MTBF in qlikview

Hi everybody!

I'm new to qlikview and my question is this:

i have a table with service calls data. every SC has a serial number related to it. the SC obviously has a date.

there is another table with serial numbers data which include manufacturing date.

is it possible to calculate manufacturing MTBF, which means the avarage time from manufacturing to the first service. every serial number might have more than one SC related to it so the time needs to be from manf date to the first SC only.

can you give me some thoughs and hints?

thanks in advance

1 Reply
swuehl
MVP
MVP

Maybe something like

=Avg( Aggr( Min( SCDateField) -  Only(ManufacturingDateField), SerialNumber))