Summarize / Count of Test Pass-Fail

[JeffQlik]

Hello - I'm new to Qlik Sense and this forum ...  

I'm trying to apply counts (measures ?) to a set of Student Test data in a single table.  All the data is for the same Test allowing for multiple re-takes until Pass.

The end results would look like:

Number in Fail Status = 2
Number in Pass Status = 3
Number in Multiple Pass = 1

I'm not sure if this should be done in the Data Load Editor or on a Sheet... 

I'm not knowing how to process the multiple records for each Student to check if all are "F" or mix of "F" & "P" or more than one "P"

I would GREATLY appreciate any thoughts, feedback, direction ! 

The end results would look like:

Number in Fail Status = 2
Number in Pass Status = 3
Number in Multiple Pass = 1

[TJO235]

Hi Jeff, 

You can either create a field on the backend with a simple 'if' statement that looks something like:

if(PassFail = 'P',1,0) as PassCount

If(PassFail = 'F',1,0) as FailCount

then, in your KPI use Count(FailCount) to get your counts. this is the most straightfoward way. you can also use set analysis right in your KPI but that can get a bit more complicated. 

If you're in your KPI you can try the below set analysis:

To count fails:

count({<PassFail = {'Fail'}>}PassFail)

To count Passes:

count({<PassFail = {'Pass'}>}PassFail)