Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count dimension in pivot table

Hi all please help me to count the failure student like the requirements in image. and sorry for bad english

Example: (Pivot Table)

Student ID      Curriculum      Pass/Fail

S0001             C1654             Fail

S0001             C6549             Fail

S0002             C9875             Fail  

S0003             C5498             Fail

S0003             C6545             Fail

S0003             C5465             Fail

S0004             C2465             Fail      

the requirement in picture:

qlik question.png

4 Replies
MK_QSL
MVP
MVP

Provide sample data for this!

ecolomer
Master II
Master II

Can you explain more, please?

sunny_talwar

Like the people before me has mentioned, we would need more details to help you resolve your issue. What is your dimension in the above chart and can you provide the sample data with its expected output?

HTH

Best,

Sunny

petter
Partner - Champion III
Partner - Champion III

I think Count() wrapped in an Aggr() should work well for this scenario:

2015-09-20 #2.png