Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I have a problem while connecting to store procedure

Hi guys,

i would ask you that i have a question regarding a store procedure

Error :

Error.png

and my procedure is :

Help.png

15 Replies
devarasu07
Master II
Master II

Hi,

for the visualization/reporting you have store that stored procedure output into qvd file. after that you can use that qvd (binary data file) for your reporting.

To save your stored procedure results into qvd, you have write something like below (make sure QVD folder exists in your machine & hub connection string) .


Store * from Students into 'lib://QVD/Students.qvd';


For more steps refer my 1st reply.


Thanks,

Deva


Anonymous
Not applicable
Author

Thanks very much for your help

but the last thing i would ask you

yesterday when i opened your word file i could not know from where can i select qvd file?

33.png

Anonymous
Not applicable
Author

Dear Deverasu

when i typed store line to store the Stored procedure in qvd i got this error

44.png

devarasu07
Master II
Master II

Hi,

before you need to do below steps,

1) Create new connection,

a) example, in your D drive, create folder called QlikSense

D:\QlikSense

2) after that you have to create new connection string from  qliksense edit script windows  (like below screen)

Name name you put it like QVD, as i mention in my below screen

Capture.JPG

3) after that, update your script like below (for creating report  based on save qvd file)

LIB CONNECT TO 'sqlserver';

Students:

load *;

SQL exec dbo.Students;

Store * from Students into 'lib://QVD/Students.qvd';

Drop table Students;

Fact:

LOAD

    Studentid,

    Firstname,

    Lastname,

    Email

FROM [lib://QVD/Students.qvd]

(qvd);

Hope this helps to you. Thanks Deva

Anonymous
Not applicable
Author

Thanks very much

Now It is working

devarasu07
Master II
Master II

Hi,

Can you help me to close this thread by marking correct. it might useful for others who is having similar issue.

Thanks Deva