Function FileName() not working after upgrade to 3.2.3

[Anonymous]

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?

[nikikoradia]

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

[Anonymous]

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]

Same issue here.

I hope Qlik fix it in the upcoming version.

[#5]

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

[Anonymous]

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

[p_verkooijen]

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)

[Anonymous]

Hello Paul,

thanks for your response.

Yes, all files are excel files!!!!

BR, Bernd

[p_verkooijen]

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

[Anonymous]

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.