Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe something like
=Avg( Aggr( Min( SCDateField) - Only(ManufacturingDateField), SerialNumber))