using if statement in pivot table.

Anonymous — Sun, 18 Oct 2015 08:50:40 GMT

i try to make code like sql to count pass & fail students and the failed one unint, two unit,..

this code to count failed three unit students. in sql server.

SELECT

distinct ACADEMIC.PEOPLE_Id, academic.degree, count(td.EVENT_ID) "fail"

FROM

ACADEMIC

left outer join transcriptdetail td on academic.people_id=td.people_id andacademic.academic_term=td.academic_term and academic.academic_year=td.academic_year

left outer join gradevalues on td.final_grade=gradevalues.grade andtd.academic_year=gradevalues.academic_year and td.academic_term=gradevalues.academic_term andtd.credit_type=gradevalues.credit_type

WHERE

academic.people_ID not in (001211102, 001210796, 001210830, 001311424, 001311428, 001311435, 001311478,001312617, 001313092)

AND ACADEMIC.ACADEMIC_YEAR =2015 and academic.status!='n'

and not(academic.academic_Session='' or academic.academic_Session='easa')

AND ACADEMIC.ACADEMIC_TERM = 'FEB'

and academic.curriculum not like 'eas%' and pass_fail='f' and enroll_separation='en' and primary_flag='y'

and add_drop_wait='a' -- and academic.degree like 'bus%'

AND ACADEMIC.PEOPLE_ID=001210007

group by academic.degree, ACADEMIC.PEOPLE_ID having COUNT(event_id)=3

Re: using if statement in pivot table.

Anonymous — Sun, 18 Oct 2015 08:51:38 GMT

maverjannet‌ can you help me please with this?

Regards.

Re: using if statement in pivot table.

Anonymous — Mon, 19 Oct 2015 13:58:11 GMT

Hi,

I'm sorry for not answering before, you can check if this is what you're looking for, please.

Regards.

Re: using if statement in pivot table.

Anonymous — Tue, 20 Oct 2015 06:10:48 GMT

It's ok, i will check it. Thanks a lot

Regard.

topic Re: using if statement in pivot table. in QlikView

using if statement in pivot table.

Re: using if statement in pivot table.

Re: using if statement in pivot table.

Re: using if statement in pivot table.