Discussion Board for collaboration on QlikView Scripting.
I load files with:
FROM ../../QVD/*DATA.qvd (qvd);
Can I count how many files i have loaded in the report?
Don't know about files but tables you can count as below
One way to achieve this would be something like this:
filename() as filename,
Count(DISTINCT filename) as FileCount
LET vFileCount = peek('FileCount', -1);
DROP TABLE FileCount;