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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
beginnertom
Contributor III
Contributor III
‎2018-06-03 10:34 AM

Multiple data calculate distinctly under specific condition

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_codeInspection_dateResultInspection_department
A1232018.04.11Failure AQC
A1232018.04.12Failure BQC
A1232018.04.14PassQC
A1242018.04.12Failure CQC
A1242018.04.14PassQC
A1252018.04.13PassQC
A1262018.04.14Pass QC
Labels (1)
Labels
710 Views
0 Likes
0 Replies