Hi everyone, I want to extract a value from my database and calculate it distinctly,
below just an example:
I want to calculate the first time success rate from below table:
The condition: no matter finally the batch pass or not, if it exists one Failure(no matter what failure), it will count as a fail batch.
Hence, based on below table, the first time success rate is
= {A123(F)+A124(F)+A125(P)+A126(P)}/A123+A124+A125+A126
=2/4
=50%
Can i calculate above result by QlikView, distinct other irrelevant data?Tks
Batch_code | Inspection_date | Result | Inspection_department |
---|
A123 | 2018.04.11 | Failure A | QC |
A123 | 2018.04.12 | Failure B | QC |
A123 | 2018.04.14 | Pass | QC |
A124 | 2018.04.12 | Failure C | QC |
A124 | 2018.04.14 | Pass | QC |
A125 | 2018.04.13 | Pass | QC |
A126 | 2018.04.14 | Pass | QC |