Count all

[manoranjan_d]

Hi in SQL we ll simply use select count(*)  as xxx from tablename to get overall count

but in QLikview load script  how to use the same query,pleas help me

example

in my load script wht i m doing

load

name,

rollno, dept;

sql select name, rollno, dept, count(*) as RecordsPerroll

from Collage

group by name, rollno, dept

order by rollno

STORE collage into (qvd);

i m getting error in that RecordsPerroll feild nit found

[sinanozdemir]

Hi,

I think you can use:

NoOfRows() and RowNo() functions to count(*). Because Count(*) is essentially the number of rows.

Hope this helps.

[Oleg_Troyansky]

1. The field RecordsPerroll is not listed in your preceding load - I'd suggest to add it there.

2. There should be a semicolon between the end of the SQL statement and the beginning of the STORE statement.

3. I'd recommend to name your table explicitly without relying to the automated naming:

collage:

load

     name,

     rollno,

     dept,

     RecordsPerroll

;

sql select name, rollno, dept, count(*) as RecordsPerroll

from Collage

group by name, rollno, dept

order by rollno

;

STORE collage into (qvd);

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[#4]

Hi, assign NoOfRows function  in a variable, displays this in text object.

Tabla:

load

name,

rollno, dept;

sql select name, rollno, dept as RecordsPerroll

from Collage

group by name, rollno, dept

order by rollno

STORE collage into (qvd);

LET vCantidadRegistros = NoOfRows('Tabla') ;

Regards.

[maxgro]

Table:

load *;

sql select name, rollno, dept, count(*) as RecordsPerroll

from Collage

group by name, rollno, dept

order by rollno

STORE collage into (qvd);