How to count the row number of a field?

[#1]

Hello everyone,

I am developing a QlikView interface that display information of a school.

I need to show the total number of courses, so i have a field called "Courses", and what i need is the row number from this field, where i will have the total course number.

I am using the expression below:

RowNo([TOTAL[<Course{,Course}>]])

But this expression returns no data. Anyone can help me on this?

Thanks

[swuehl]

Try

COUNT(DISTINCT Courses)

instead.

[#3]

sum(if(courses<>null,1,0)

[crystles]

If you just need a count, in the script you can just put a 1 as Count or Sum Field.

CourseName

CourseTeacher

1 as SumCourses

This will give you a field with the number 1 in it. So all you have to do in the table is Sum([SumCourses]) to get the total number of courses.

[sunilkumarqv]

Hi Rodringo

hope this will help you

Script

Data:

Load

Recno() as ID,

Courses resident from datasoruce;

Expression: Count(Distinct ID)

[raajaswin]

in Script:

Table:

Load

Course,

Rownum()

Resident Old_Table;

[dineshkumar]

hi caldas,

        In edit script do the following to get row number there is a function called rowno() use this while loading your data for the row number. and is expression you can count.. Count( Distinct Course).

for eg:

load

name,

address,

course,

rowno() as Serial No.

from >>>>>>.