Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load Store Procedure In qlik Sense

hi to all.

I am new to SQL and Qlik Sense. I want make a dashboard by 5 Store Procedure by qlik sense.I cant load SP in qlik sense.just I know SP's name(rptSP_SaleDashboard_CustomerType) and parameters(@scuCompanyID=121////@scuCmpyID=66/////@UserID=181)

plz help me to done this task.

plz clearly explain how to i must write script by this information.

15 Replies
Not applicable
Author

I do this job. but it give me Connector reply error.

shraddha_g
Partner - Master III
Partner - Master III

Connection is created successfully?

Are you able to fetch a table from database?

Before Executing a SP try to fetch a simple table to check whether your connection is successfully established with database

Not applicable
Author

i think connection is created successfully because i can insert tables by insert data.pls help me.i must do this tomarrow...

shraddha_g
Partner - Master III
Partner - Master III

what script you have used for SP?

Can you take screenshot?

Not applicable
Author

`

188.75.73.74 is my server addres and MabnaERP is mu database name and rptSP_SaleDashboard_DailySale is my sp name and 121 and 66 and 181 is my parameters

Capture.PNG

shraddha_g
Partner - Master III
Partner - Master III

Remove Load * and try Load Fieldname (Try with 1 fieldname)