Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikSense isn't fetching filename from Xlsx format

Hi All,

I am unable to fetch filename from xlsx files in QlikSense. but it fetches the filename form xls file.

below is the script which i have used:

LOAD

    CIN,

    COMPANY_NAME,

    COMPANY_CLASS,

    COMPANY_CATEGORY,

    COMPANY_SUBCAT,

    COMPANY_STATUS,

    DATE_OF_REGISTRATION,

    REGISTERED_STATE,

    "Authorized Capital  (Rs.)",

    "PAIDUP_CAPITAL (RS.)",

    PRINCIPAL_BUSINESS_ACTIVITY_CODE,

    REGISTERED_OFFICE_ADDRESS,

    EMAIL_ID,

    "LATEST ANNUAL REPORT FILING FY END DATE",

    "LATEST BALANCE SHEET FILING FY END DATE",

    FileName() as File_Name

FROM [lib://Company Master Data/Andaman_Nicobar_Islands_2016.xls]

(biff, embedded labels, table is Sheet2$);

Please help!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Ah, sorry, seems I've tested on an older version.

Maybe the issue is related to

Function FileName() not working after upgrade to 3.2.3

View solution in original post

3 Replies
swuehl
MVP
MVP

Works for me also using an .xlsx file.

What do you get instead of the file name? NULL?

Could you post the script that does not work? (and a sample xlsx file that you are trying to load)

On which version of QS are you?

felipedl
Partner - Specialist III
Partner - Specialist III

Doesn't seem to work for me either.

Example xlsx is attached and i'm using the QS version of the image below.

Sample.png

QSLicense.png

Script im using

x:

LOAD 

    A,

    B,

    C,

    FileName() as FileName,

    FilePath() as FilePath,

    FileDir() as FileDir,

    FileExtension() as FileExtension,

    FileSize() as FileSize,

    FileTime() as FileTime

FROM [lib://Desktop/Sample.xlsx]

(ooxml, embedded labels, table is Plan1);

swuehl
MVP
MVP

Ah, sorry, seems I've tested on an older version.

Maybe the issue is related to

Function FileName() not working after upgrade to 3.2.3