Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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