Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anilb1603
Contributor III
Contributor III

Reading data from sql server stored procedure is not working

Hi Guys,

I am trying read the data from stored procedure, it has 3 input parameters. I wrote the sql script as below in qlik sense. The qlik sense loading is went successful but I don't see any actual data loaded into qlik sense.

Am I missing anything here? Any help would appreciated.

I used OLEDB connection here.

Data:
Load *;
SQL Exec InfDB_QA.dbo.spReport_Results
@TemplateId = 232
,@StartDate = '8/11/2019'
,@FinishDate = '9/15/2019'
;

Thanks,

Anil

2 Replies
treysmithdev
Luminary
Luminary

Maybe try this:

Data:
Load *;
SQL Exec InfDB_QA.dbo.spReport_Results '232' '8/11/2019' '9/15/2019';

 

You might have to adjust your stored proc to have parameters to point to those variables. I don't believe Qlik can pass those variable statements through the driver.

 

Also, make sure your dates are the default format of the fields so that they are interpreted correctly on the SQL side.

Blog: WhereClause   Twitter: @treysmithdev
Anilb1603
Contributor III
Contributor III

Thanks @treysmithdev

I tried this.

Data:
Load *;
SQL Exec InfDB_QA.dbo.spReport_Results '232', '8/11/2019', '9/15/2019';

Again the load is successful but I don't see any actual data loaded into qlik.

The date format looks fine I executed the same query in SSMS, it is executed successfully and provided output.