topic count excluded in QlikView

count excluded

Anonymous — Mon, 11 Aug 2014 07:45:00 GMT

Hi,

I have a
scenario of counting students who did not take or failed the compulsory course
depending on their major.

We are
using an existing Model, and we cannot modify any part of it. So i need to
figure out how to do this thru set analysis or expression.

In the
example below, i have 4 students major in Accounting, their compulsory course
is ACCT111.

Based on
the class table, student 1,2,4 took ACCT111 but only Student 1 and 2 passed.
and student 3 did not take it at all.

When i
write the expression, the result count would be 2.

Student 3
who did not take the course and student four who failed.

Really
appreacitae your help on this. Many thanks!

Student Master

Class Table

DavidFoster1 — Mon, 11 Aug 2014 07:47:44 GMT

Look at using the E syntax in set analysis

Anonymous — Mon, 11 Aug 2014 09:28:17 GMT

hi,

thanks. can you share the syntax using the sample fields ive given?

Ive been trying to but couldnt get the result that i need...

really appreaciate the help. Thanks!

PradeepReddy — Mon, 11 Aug 2014 10:15:13 GMT

Try something like this....

Total Students : Count({$<Major={'Accounting'}>}Student)

Exams Written : Count({$<Major={'Accounting'},Grade={'A','B','D'}>}Student)

Exams Passed : Count({$<Major={'Accounting'},Grade={'A','B'}>}Student)

Exams Failed : Count({$<Major={'Accounting'},Grade={'*'}-{'A','B'}>}Student)

Anonymous — Tue, 12 Aug 2014 03:54:16 GMT

many thanks Pradeep for the tips.. I was able to figure it out using your reply..

many thanks, really appreciate it.. 😃