Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
shraddha_g
Partner - Master III
Partner - Master III

Try

Connect to database and then

SQL Exec StoredProcedureName(Parameter1, Parameter2,...etc)

Not applicable
Author

hi shraddha.tanks for your response. I do your guide like follow pic

Capture.PNG

but i see this window

Capture.PNG

Not applicable
Author

where i must insert my database name?

Not applicable
Author

dear shraddha.g can you share your script?

rittermd
Master
Master

This is an example of what I am doing in one of my apps.  I run the SP 3 times with different parameters.

Make sure that your data connection to SQL is working.

LIB CONNECT TO 'Prod_HHMapping (win-ivtiroi5taf_mritter)';

Functional_BM_CM:

SQL

exec dbo.batch_XML_CFORatings 1, '4/01/2016','4/30/2016','M','STR';

SQL

exec dbo.batch_XML_CFORatings 1, '4/01/2016','4/30/2016','S','STR';

SQL

exec dbo.batch_XML_CFORatings 1, '4/01/2016','4/30/2016','C','STR';

shraddha_g
Partner - Master III
Partner - Master III

have you created database connection?

Not applicable
Author

No.I dont khnow anything about qlik.i want connect to 5 sp.plz explain for me step by step.tanks

Not applicable
Author

tanks Ritter. plz explain for me what is 'Prod_HHMapping (win-ivtiroi5taf_mritter)' and Functional_BM_CM? which one is server name and which one is database name?

shraddha_g
Partner - Master III
Partner - Master III

Create OBDC connection to your Database in ODBC Data Source (64 Bit) - >System DSN of your Server

In load editor,On right side pane there is a option called Create Connection.

Select ODBC - > Choose Connection from List of ODBC Data Source as created previously. -> Provide Username Password - > Test Connection ->  If Success  then Give name for Connection and Click on Apply.

Insert

In Mark's Example Prod_HHMapping (win-ivtiroi5taf_mritter) is name of Database connection.

After that

to execute Stored procedure,

SQL

exec StoredProcedurename Parameter1,Parameter2,Parameter3 ...Etc