topic Re: Count loaded files? in QlikView

Count loaded files?

qlikconsultant — Mon, 20 Apr 2015 09:23:44 GMT

I load files with:

Table:

LOAD *;

SELECT *

FROM ../../QVD/*DATA.qvd (qvd);

Can I count how many files i have loaded in the report?

MK_QSL — Mon, 20 Apr 2015 09:25:17 GMT

Don't know about files but tables you can count as below

NoOfTables()

marcus_malinow — Mon, 20 Apr 2015 09:46:28 GMT

One way to achieve this would be something like this:

Table:

LOAD

filename() as filename,

FROM

[../../QVD/*DATA.qvd] (qvd);

FileCount:

LOAD

Count(DISTINCT filename) as FileCount

RESIDENT Table;

LET vFileCount = peek('FileCount', -1);

DROP TABLE FileCount;