Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have upgraded my Qlik Sense Desktop version from 3.2.2 to 3.2.3. and now the script function FileName() is not working anymore. It does not return any values. Anyone else experiencing the same problems?
Logged a case with Qlik this is the response I received:
This is in reference to your case number - 01099753
Subject: Since 3.2.4 function filename() returns no data
A new comment has been posted related to your case :
Thank you for contacting Qlik Support.
I have tried to call you but I couldn't reach you.
If all the files are Excel files, then it is a know bug (bug id QLIK-76421). The bug is already solved internally and most probably will be available in the next service release.
Please confirm that you are talking solely about excel files. It should work fine with for instance qvd or txt files.
Please let me know if (assuming of course that you are talking only about Excel files) we can close the case or if you would prefer to keep it open until there is a of...(continued)
For Each File in FileList('[lib://Excel/Budget*.xlsx]')
Subfield('$(File)', '\', SubstringCount('$(File)', '\') + 1) AS Filename
FROM [$(File)] (ooxml, embedded labels, table is Data);
thanks a lot for your support.
Your workaround runs good, but we have no time to change all your scripts in acceptable time.
Best regards, Bernd
Von: Paul Verkooijen
Gesendet: Freitag, 19. Mai 2017 15:28
An: Kirchberger, Bernd <Bernd.Kirchberger@flabeg.com>
Betreff: Re: - Function FileName() not working after upgrade to 3.2.3
CAUTION: This email is from an external source. Exercise caution before clicking links or opening attachments.