Can't read from local .xlsx file

[nando1974]

When i write in the script editor like this:

Set Mypath = C:\MyFolder\;
LOAD * from $(Mypath)MyFile1.xlsx;

and then press load i get the following message:

No qualified path for file: ***

Any ideas what I am doing wrong?

thanks in advance;

/Fernando

[tresesco · Accepted solution]

Qlik Sense is different from qlikview when it comes to reload path. In qs, absolute paths don't work; you have to create a connection to a folder/file/db before you can fetch the data. And then your load script would look something like:

Load  *

FROM [lib://<yourconnName>/.../abc.xlsx];

[nando1974]

Hi and many thanks

I have been trying to create a connection but i only get this :

 

 

from this

 

any ideas what i am doing wrong ?

Thanks anyway and happy new year!

/Fernando 

[tresesco]

It seems that you are working on hub and you don't have permission to create a folder connection. Your qs admin should be able to help here.

[nando1974]

Hi and thanks

The thing is at work I use the enterprise version of Qliksense.

But this example is from my own project and i use the cloud version of Qliksense.

So i guess I am my own administrator.

Also i tried to load the .xlsx file manually and i get the same message:

No qualified path for file: ***

ALthough loading the same file (manually) in a new app works.

I am not sure how to solve this?

I guess this folder connection is crucial, any other ideas on how to create a folder connection on the cloud version?

Thanks in advance!

[nando1974]

Hi I managed to unlock the auto generated script with the unlock button.

I still cannot edit the path for the folder though .

I get this:

Many thanks 

/Fernando

[ArnadoSandoval · Accepted solution]

Hi @nando1974 

We cannot manage the folder in QlikSense Cloud, what we can do is create a new "Spaces" they behave like folders; you can create these spaces following this path:

Administration à Spaces

You can add files to any of your spaces with the Data Load Editor, by selecting any of the spaces in the right panel:

Once you open the Space, it allows you to add your files, these files are saved by Qlik in the cloud.

Hope this helps,

[nando1974 · Accepted solution]

Hi and many thanks

Sorry for the late reply.

I think i managed to create a space.

I also managed to add my file and it generated an autoscript that loaded fine except for one warning. 

I think this solves my problem,  many thanks

/Fernando