Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
awadah25
Creator II
Creator II

count pass/fail students in pivot table

maverjannetbunnyqlikMarcoWedel

this is live example for count pass/fail students..

i need to count the failed students in pivot table like the example

regards.

13 Replies
awadah25
Creator II
Creator II
Author

It's work thanks

what about [ Passed all unit] i try to use this two expression but it's all wrong >>

=if(Pass_Fail <> 'F',count( Pass_Fail))

=count(DISTINCT if(PASS_FAIL <> 'F', People_ID))

Regard.

rubenmarin

Hi Mohammed, maybe with:

count(DISTINCT People_ID)-count(DISTINCT{<PASS_FAIL = {'F'}>} People_ID)


Or:

count(DISTINCT People_ID)-count(DISTINCT if(PASS_FAIL <> 'F', People_ID))


If it can be people_Id without evalutions you should filter those:

count(DISTINCT{<PASS_FAIL = {'F','P'}>} People_ID)-count(DISTINCT{<PASS_FAIL = {'F'}>} People_ID)


Not applicable

if i was you i would use:

Count(distinct if((Aggr(sum(if(PASS_FAIL = 'F',1,0)), People_ID))=0,People_ID,0))

The reason being, we want to calculate this over People_ID. Hope that makes sense.

Regards

RL

bunnyv123
Creator II
Creator II

Hi,

There at total it should be passed + Failed.

Because there are some records which are not either comes under Passed or Failed.

Thanks,

Bunny