Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qlikconsultant
Contributor II

Count loaded files?

I load files with:

Table:

LOAD *;

SELECT *

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

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

Tags (1)
2 Replies
MVP
MVP

Re: Count loaded files?

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

NoOfTables()

marcus_malinow
Valued Contributor III

Re: Count loaded files?

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;