Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
MVP
MVP

Re: QlikSense isn't fetching filename from Xlsx format

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

3 Replies
MVP
MVP

Re: QlikSense isn't fetching filename from Xlsx format

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
Valued Contributor III

Re: QlikSense isn't fetching filename from Xlsx format

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);

MVP
MVP

Re: QlikSense isn't fetching filename from Xlsx format

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