Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

petravanderhoek
New Contributor

Function FileName() not working after upgrade to 3.2.3

Hi all,

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?

9 Replies
nikikoradia
New Contributor II

Re: Function FileName() not working after upgrade to 3.2.3

I had the same issue, had to roll back to 3.2.2

chryslersupport
New Contributor

Re: Function FileName() not working after upgrade to 3.2.3

We have the same issue.  Works on the desktop of 3.2.3 but not on the server....

Please tell me there is a less buggy 3.2.4 coming soon!

cezarjustino
New Contributor

Re: Function FileName() not working after upgrade to 3.2.3

Same issue here.

I hope Qlik fix it in the upcoming version.

Not applicable

Re: Function FileName() not working after upgrade to 3.2.3

I have the same issue, is not working in desktop mode.

kirchberger
New Contributor

Re: Function FileName() not working after upgrade to 3.2.3

Dear all, we have the same problem after upgrade to 3.2.4!!!!

p_verkooijen
Valued Contributor

Re: Function FileName() not working after upgrade to 3.2.3

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 :

Hi Paul.

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)


kirchberger
New Contributor

Re: Function FileName() not working after upgrade to 3.2.3

Hello Paul,

thanks for your response.

Yes, all files are excel files!!!!

BR, Bernd

p_verkooijen
Valued Contributor

Re: Function FileName() not working after upgrade to 3.2.3

A workaround:

For Each File in FileList('[lib://Excel/Budget*.xlsx]')

     BudgetData:

     LOAD

          Budget.

          Date,

          Subfield('$(File)', '\', SubstringCount('$(File)', '\') + 1) AS Filename

     FROM [$(File)] (ooxml, embedded labels, table is Data);

Next File

kirchberger
New Contributor

Re: Function FileName() not working after upgrade to 3.2.3

Hi Paul,

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.

Community Browser