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?

[#2]

hi..

Thanks for the reply.

Actualy i need the report in following format

->here the first column is the branch code.

->second is Total no of employees

for each xam i should get the count as separate column

here technician,pro technician,diagnosis technician,master technician are Name of exams.

there are possibilities like an employee can write all four exams so his count should be shown only in the latest exam where he is passed.

[#3]

any help on this please?

[Mahamed_Qlik]

Hi Rohit,

We tried at our end but the count is 0 (Zero).

We have checked the source database in which many number of students have passed.

[#5]

helloo..

Any Update??