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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Parameter passing through Qlikview to SQL procedure

I have table named Inventory and it has data like as follows:

ID Product Warehouse Quantity

142Green beansNY100
214PeasFL200
825CornNY140
512Lima beansNY180
491TomatoesFL80
379WatermelonFL85
NULLNULLNULLNULL


I made a Stored Procedure as follows:

CREATE PROCEDURE sp_GetInventory
@location varchar(10)
AS
SELECT Product, Quantity
FROM Inventory
WHERE Warehouse = @location

When I execute it as:

Execute sp_GetInventory FL

It gives result as required by the stored proceduer given above.

CAn any one help me, I want to pass the parameter to the stored procedure through QlikView. such as if i want to place FL in input box so it gives data according FL with executing stored proceudre.

Warm Regards,

Khalid



0 Replies