Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
JACKNIEKERK
Creator
Creator

filling a list from a text file into Qlikview

I found on a forum wich works ok a way to click in list to show a PDF
Now i added them by hand in the load part of qlikview , one by one , by name
How to get them every time when reloading qlikview , reading a text file wich will contain all these documents name
instead of adding manualy in the loading  part, wich would be not meaningfull

1 Solution

Accepted Solutions
JACKNIEKERK
Creator
Creator
Author

Spoiler
ok after changing in:

for each File in filelist ('K://QLIKVIEW-2019/SUNKIP/*.pdf')
LOAD
'$(_File)' as DocumentLink,
'PDF Document ' & Subfield( '$(_File)' , '/', -1) as DocumentName
autogenerate 1;
next File

to this:

for each File in filelist ('K:/QLIKVIEW-2019/SUNKIP/*.PDF')
LOAD
'K:/QLIKVIEW-2019/SUNKIP/' & '$(File)' as DocumentLink,
Subfield( '$(File)' , '/', -1) as DocumentName
autogenerate 1;
next File

the problem was the  underscore in  '$(_File)'

thanks for startup

regards Jack

View solution in original post

3 Replies
Vegar
MVP
MVP

Try something like this

for each _File in filelist ('K://QLIKVIEW-2019/SUNKIP/*.pdf')
  LOAD
    '$(_File)' as Link,
    'PDF Document ' & Subfield( '$(_File)' , '/', -1) as DocumentName
  autogenerate 1;
next _File

JACKNIEKERK
Creator
Creator
Author

hello , getting close  I think

I have now in Load

DocTable:
//==============
LOAD 'PDF Document ' AS DocumentName, 'K:/QLIKVIEW-2019/SUNKIP/1012.pdf' AS DocumentLink // this thus set fixed
AUTOGENERATE 1;

for each File in filelist ('K://QLIKVIEW-2019/SUNKIP/*.pdf')
LOAD
'$(_File)' as DocumentLink,
'PDF Document ' & Subfield( '$(_File)' , '/', -1) as DocumentName
autogenerate 1;
next File

It should show 4 files wich are there it shows one  but format , I mean as result path is not 

ok, and or working see attched  screen please, so i do something still wrong

please advice

 

JACKNIEKERK
Creator
Creator
Author

Spoiler
ok after changing in:

for each File in filelist ('K://QLIKVIEW-2019/SUNKIP/*.pdf')
LOAD
'$(_File)' as DocumentLink,
'PDF Document ' & Subfield( '$(_File)' , '/', -1) as DocumentName
autogenerate 1;
next File

to this:

for each File in filelist ('K:/QLIKVIEW-2019/SUNKIP/*.PDF')
LOAD
'K:/QLIKVIEW-2019/SUNKIP/' & '$(File)' as DocumentLink,
Subfield( '$(File)' , '/', -1) as DocumentName
autogenerate 1;
next File

the problem was the  underscore in  '$(_File)'

thanks for startup

regards Jack