Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

aryan385
New Contributor

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