topic count pass fail in QlikView

count pass fail

Anonymous — Sun, 18 Oct 2015 09:51:35 GMT

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.

Re: count pass fail

MarcoWedel — Sun, 18 Oct 2015 22:18:49 GMT

please post sample data/app.

thanks

regards

Marco

Re: count pass fail

fkeuroglian — Mon, 19 Oct 2015 01:08:04 GMT

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.

Re: count pass fail

ramasaisaksoft — Mon, 19 Oct 2015 06:08:54 GMT

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.

Re: count pass fail

Anonymous — Mon, 19 Oct 2015 06:54:37 GMT

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.

Re: count pass fail

avinashelite — Mon, 19 Oct 2015 06:58:51 GMT

Hi Mohammed,

Please don't post the same thread multiple time