topic Re: count pass/ fail in pivot table in QlikView

count pass/ fail in pivot table

Anonymous — Mon, 19 Oct 2015 10:43:04 GMT

I need to count the number of students under a specific major (ex: engineering degree, business degree) with a count of one fail grade for a specific semester, and then the number of students with a count of exactly 2 failed grades, 3 failed grades and so on.

Re: count pass/ fail in pivot table

rubenmarin — Mon, 19 Oct 2015 10:53:39 GMT

Hi Mohammed, please look expressions at attached file.

Re: count pass/ fail in pivot table

hic — Mon, 19 Oct 2015 11:09:59 GMT

You can also create a pivot table with the following dimension/measure:

Dimension: =Aggr(Count({$<PASS_FAIL={F}>} PASS_FAIL),People_ID)

Expression: Count(distinct People_ID)

Then you will get a table that classifies your students according to number of failed grades:

In other words: given the current selection, 63 people have failed one test, 40 have failed 2 tests, etc.

HIC

Re: count pass/ fail in pivot table

Anonymous — Mon, 19 Oct 2015 11:25:14 GMT

sorry but where is the attachment file ?

Re: count pass/ fail in pivot table

Anonymous — Mon, 19 Oct 2015 11:26:18 GMT

I will try this idea.

Regard.

Re: count pass/ fail in pivot table

rubenmarin — Mon, 19 Oct 2015 11:26:39 GMT

It's attached in my previous post: