Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Hi all, i cant add XLSX files ? there's an error message when i reloaded files ?


Hello everybody, i leave a problem to add XLSX files and créate my first dashboard... so frustrated !

when i add 3 different XLSX files, and recharged them i received an error message ( see word doc), and cannot use QVW...

someone could help me please ?....

Thanks a lot to all

regards

Franck

Hi friends, thanks for your response, i add the total files of my default script;

Im not very with IT language, im sales manager, and i need to join 3 XLSX files.

The problem arrive with the first files named GSR 6, ( i need to add GSR 5 and 4...)

I dont understand if i do write something after LOAD ? and what ( im sorry for my poor skills for that...)

thanks for your additionnal comments

Franck

6 Replies
MVP
MVP

Re: Hi all, i cant add XLSX files ? there's an error message when i reloaded files ?

from your doc is difficult to guess, post all your script, if possible your qlik doc and excel files

it seems the excel file is missing

in your script you can use the following statement to know if the problem is after first, second or last excel load

exit script;

here a video to get started with load from excel

Video: Load Data from Excel

here a doc on loading data

LOAD data into QlikView

MVP
MVP

Re: Hi all, i cant add XLSX files ? there's an error message when i reloaded files ?

Your word document doesn't show the complete LOAD statement inlcuding all fields, the FROM part with the file format specifications.

Have you tried the table wizard (from script editor, 'Table files...' on Data tab)?

fkeuroglian
Honored Contributor

Re: Hi all, i cant add XLSX files ? there's an error message when i reloaded files ?

Hi,

the root of the file xls is incorrect, please check that, the folder has to be similar that you have the xls.

good luck

try to attached the qvw and we can fix

Fernando

Not applicable

Re: Hi all, i cant add XLSX files ? there's an error message when i reloaded files ?

Hi Swuehl,

yes i try with the script editor etc, but unfortunatly :-(

i put on last message the complete LOAD statement, including the FROM part ?

tx

Franck

MVP
MVP

Re: Hi all, i cant add XLSX files ? there's an error message when i reloaded files ?

You tried with the table wizard but without success?

As Fernando already assumed, it seems that the excel file is not where QV expects the file to be.

In your LOAD statement, you don't specify the absolute path, so QV expect it to be in the same folder as the QV application (.qvw file) itself. Try specifiying the complete path or copy the Excel file to the same directory as your application is in.

Not applicable

Re: Hi all, i cant add XLSX files ? there's an error message when i reloaded files ?

Go to Start - Run , paste this "C:\Users\chevaf1\Desktop\images\GSR_SET6_DATA.xlsx" and see if the document opens. Either its not in that path , or you don't have access rights.

Try this to fix the issue

Create a new folder in your desktop and copy the excel files there. Create a Qlikview document in that folder and use the following code

LOAD *

FROM

[GSR_SET6_DATA.xlsx]

(ooxml, embedded labels, table is Sheet1);

replace sheet1 with your sheet name if needed.

Community Browser