Re : max date based on a field

[#1]

Hi all

I have a requirement as follows

my data is regarding the exams done on different courses.

same student can write more than 1 exam.

now i have to take the count of students which has been passed in each exam.

if a student attends more than 1 exam then he should be counted on the latest exam based on the exam date.

how can it be achieved?

[tresesco]

Could you post a sample qvw with sample data? It seems, FirstSortedValue() would be useful here.

[#3]

please find the attached.

[tresesco]

Is there any possibility that an employee attempted an exam and passed, but still he/she can attempt again for the same exam, and in that case if he/she fails (in the latest attempt) he/she should be considered as FAILED?

[rohit214]

Hi Reena,

Either you can write script in back end Like

Main:

Load

*

From XYZ.xls;

Load

Employee Code,

Max(Exam Date)    As Exam Date_MAX,

Resident Main group by Employee Code;

or

you can use expression in front end

=count( {<Employee Code={"$(=FirstsortedValue(Exam Date,Employee Code))"},Exam Result={'Pass'}>}Employee Code)

[#6]

no,the same exam he/she wont be attending again.there is no such chances..

[#7]

Thank yu...

i ll try this.. but how can i get the latest exam based on exam date??

[tresesco]

Like attached qvw?

[rohit214]

same expression

-firstsortedvalue(Exam,Examdate)

[anbu1984]

=Count(If(Aggr(FirstSortedValue([Exam Result],-[Exam Date]),[Employee Code])='Pass',1))