9 Replies Latest reply: May 22, 2017 3:29 AM by Bernd Kirchberger

Function FileName() not working after upgrade to 3.2.3

Petra van der Hoek May 9, 2017 8:02 AM

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

Nikita Koradia May 9, 2017 8:36 AM (in response to Petra van der Hoek)

I had the same issue, had to roll back to 3.2.2
Like Show 0 Likes (0)

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

Larry Travnicek May 9, 2017 11:47 AM (in response to Petra van der Hoek)

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!
Like Show 0 Likes (0)

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

Cezar Justino May 11, 2017 2:07 PM (in response to Petra van der Hoek)

Same issue here.

I hope Qlik fix it in the upcoming version.
Like Show 0 Likes (0)

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

Lina Gonzalez May 15, 2017 2:45 PM (in response to Petra van der Hoek)

I have the same issue, is not working in desktop mode.
Like Show 0 Likes (0)

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

Bernd Kirchberger May 17, 2017 6:40 AM (in response to Petra van der Hoek)

Dear all, we have the same problem after upgrade to 3.2.4!!!!
Like Show 0 Likes (0)

Actions
- Re: Function FileName() not working after upgrade to 3.2.3
  
  Paul Verkooijen May 18, 2017 6:49 AM (in response to Bernd Kirchberger)
  
  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)
  
  Like Show 1 Like (1)
  
  Actions
  - Re: Function FileName() not working after upgrade to 3.2.3
    
    Bernd Kirchberger May 18, 2017 7:06 AM (in response to Paul Verkooijen )
    
    Hello Paul,
    thanks for your response.
    Yes, all files are excel files!!!!
    BR, Bernd
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: Function FileName() not working after upgrade to 3.2.3
      
      Paul Verkooijen May 19, 2017 9:27 AM (in response to Bernd Kirchberger)
      
      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
      
      Like Show 1 Like (1)
      
      Actions
      - Re: Function FileName() not working after upgrade to 3.2.3
        
        Bernd Kirchberger May 22, 2017 3:29 AM (in response to Paul Verkooijen )
        
        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.
        
        Like Show 0 Likes (0)
        
        Actions