Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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;

Community Browser