topic Re: Count all in QlikView

Count all

manoranjan_d — Tue, 15 Sep 2015 18:38:36 GMT

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

Re: Count all

sinanozdemir — Tue, 15 Sep 2015 19:20:57 GMT

Hi,

I think you can use:

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

Hope this helps.

Re: Count all

Oleg_Troyansky — Tue, 15 Sep 2015 19:23:45 GMT

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

Re: Count all

Tue, 15 Sep 2015 19:29:06 GMT

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.

Re: Count all

maxgro — Tue, 15 Sep 2015 19:49:14 GMT

Table:

load *;

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

from Collage

group by name, rollno, dept

order by rollno

STORE collage into (qvd);