Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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)