count pass fail

[Anonymous]

I use this query in SQL to count PEOPLE_Id who failed with 3 EVENT_ID

can i use left outer join in qlikview like this query ?!

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 and academic.academic_term=td.academic_term and academic.academic_year=td.academic_year

left outer join gradevalues on td.final_grade=gradevalues.grade and td.academic_year=gradevalues.academic_year and td.academic_term=gradevalues.academic_term and td.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

I need the expression to give me the same result in qlikview using Pivot Table.

[MarcoWedel]

please post sample data/app.

thanks

regards

Marco

[fkeuroglian]

Hi

You can use the same select SQL that you use and put in the script in qlikview

Try to explain better what you want or put an example to be easier to help you

Fernando K.

[ramasaisaksoft]

Hi Awadah,

First of all please load this same query in Qv.If that query loads then try to create a chart as per u r wish.

if not we will change that in Expression as per our output requirement.

pls try once else pls post some sample data and tried .qvw file with out put requirement.

[Anonymous]

Dear Rama,

I already post the sample data in other discussion, check it please and i will try to type the same code in qlikview.

Regards.

[avinashelite]

Hi Mohammed,

Please don't post the same thread multiple time