Parameter passing through Qlikview to SQL procedure

Wed, 23 Jun 2010 13:42:51 GMT

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

ID Product Warehouse Quantity

142	Green beans	NY	100
214	Peas	FL	200
825	Corn	NY	140
512	Lima beans	NY	180
491	Tomatoes	FL	80
379	Watermelon	FL	85
NULL	NULL	NULL	NULL

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

topic Parameter passing through Qlikview to SQL procedure in QlikView

Parameter passing through Qlikview to SQL procedure