Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

QlikView returning a XML line as output for a procedure call, whereas QlikSense returning data perfectly

I am unable to execute the stored procedure in QV using below line of code. In QlikSense it is getting executed correctly with data. In QlikView it is giving one column with XML version (attached below). It is although giving correct count of records in XML output.


Checks Done:-

Database Grants are verified for the procedure and for the QV user

I am able to execute the procedure in database manually.


QV Code:-

Test:

load

*;

$(must_include=../Datasources/envconfig.qvs);

SQL exec dbo.ABC;

store Test into [../QVD/Test.qvd];

DROP table Test;

Test_Main:

Load

*

FROM

[../QVD/Test.qvd];

QV Issue.PNG

0 Replies