topic Re: Function FileName() not working after upgrade to 3.2.3 in App Development

Function FileName() not working after upgrade to 3.2.3

Anonymous — Tue, 09 May 2017 12:02:36 GMT

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?

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

nikikoradia — Tue, 09 May 2017 12:36:57 GMT

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

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

Anonymous — Tue, 09 May 2017 15:47:10 GMT

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!

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

cezarjustino — Thu, 11 May 2017 18:07:21 GMT

Same issue here.

I hope Qlik fix it in the upcoming version.

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

Mon, 15 May 2017 18:45:10 GMT

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

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

Anonymous — Wed, 17 May 2017 10:40:47 GMT

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

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

p_verkooijen — Thu, 18 May 2017 10:47:27 GMT

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)

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

Anonymous — Thu, 18 May 2017 11:06:20 GMT

Hello Paul,

thanks for your response.

Yes, all files are excel files!!!!

BR, Bernd

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

p_verkooijen — Fri, 19 May 2017 13:27:34 GMT

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

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

Anonymous — Mon, 22 May 2017 07:29:17 GMT

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.