Multiple data calculate distinctly under specific condition

beginnertom — Sun, 03 Jun 2018 14:34:15 GMT

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

topic Multiple data calculate distinctly under specific condition in QlikView