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];