Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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];
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,
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
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];
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
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.
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!
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
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,
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