Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
COUNT(DISTINCT Courses)
instead.
sum(if(courses<>null,1,0)
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.
Hi Rodringo
hope this will help you
Script
Data:
Load
Recno() as ID,
Courses resident from datasoruce;
Expression: Count(Distinct ID)
in Script:
Table:
Load
Course,
Rownum()
Resident Old_Table;
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 >>>>>>.