Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
FPC
Contributor II
Contributor II

Can't connect to my own C disk Qliksense Desktop

Hi, I'm new to QlikSense, but I'm currently working on a QVW I built in Qlikview. 

I'm working on "Qliksense Desktop".

The main issue I have is that, I used the QVW on Qliksense, built a layout for all the data I needed, but when I try to reaload the data (I used to have data until April 19, now I have data until June19) the following error jumps:

 

Se ha producido el siguiente error: (Error discl. in spanish)
Connection not found: C:
 
El error se ha producido aquí: (Error discl. in spanish)
LOAD MANDT, MATNR, SPRAS, MAKTX, MAKTG FROM lib://C:\Users\fernando.pinto\Desktop\FDO\Qlikview\SAP\MAKT.qvd(qvd)
 
I don't get the error, it says it doesn't found my C disk it's ridiculous. Can someone help me pls 
 
Thanks in advance, best regards
Labels (1)
1 Solution

Accepted Solutions
FPC
Contributor II
Contributor II
Author

Don't bother I fixed the issue... 

It was my connection, I never realized that the path should be related to the connection path ...

Anyway, it's great to know I wasn't so far away ahahaha 

 

Thanks for the help, hope u be well

 

Best Regards

View solution in original post

7 Replies
Lisa_P
Employee
Employee

The path names in QlikView and QlikSense are different, so if you converted a QlikView doc to a Qlik Sense app, then you need to set up connections to get to your data.
This can be done in the data load editor, create new connection, then point to the folder where your file lives either by clicking the path or pasting it in and giving it a name like SAP.
Then change the name of the from path in your load statement to
.. FROM [lib://SAP/MAKT.qvd](qvd);
FPC
Contributor II
Contributor II
Author

Hi thanks for the answer. 

If I had a SET to declare the variable path how should I fix the sentence. The error I showed comes from this Set/Let (tried both).

SET QVDPATH='lib://C:\Users\fernando.pinto\Desktop\FDO\Qlikview\SAP\';

 

LOAD MANDT,
MATNR,
SPRAS,
MAKTX,
MAKTG
FROM $(QVDPATH)MAKT.qvd(qvd);

Where should I make the changes? 

Thanks in advance

FPC
Contributor II
Contributor II
Author

Hi thanks for the answer. 

If I had a SET to declare the variable path how should I fix the sentence. The error I showed comes from this Set/Let (tried both).

The code looks like this: 
SET QVDPATH='lib://C:\Users\fernando.pinto\Desktop\FDO\Qlikview\SAP\';

LOAD MANDT,
MATNR,
SPRAS,
MAKTX,
MAKTG
FROM $(QVDPATH)MAKT.qvd(qvd);

Where should I make the changes? 

Thanks in advance

Lisa_P
Employee
Employee

This is a great way to solve the issue.

Can you send a screenshot of your Data Load progress output ?

FPC
Contributor II
Contributor II
Author

Here it is. The print is in spanish do you need the translation? 

 

Let me know thanks in adv.

 

 

2019-07-11 00_38_14-Qlik Sense Desktop.png

Lisa_P
Employee
Employee

You need to create a connection on the right hand side
FPC
Contributor II
Contributor II
Author

Don't bother I fixed the issue... 

It was my connection, I never realized that the path should be related to the connection path ...

Anyway, it's great to know I wasn't so far away ahahaha 

 

Thanks for the help, hope u be well

 

Best Regards