Fetch the data from SP to QlikView with input parameter.

sona_sa — Mon, 17 Nov 2014 11:26:30 GMT

Hello Team,

I have a Store Procedure with 5 Input parameters. Now I want to fetch the data for with same input parameter and that data I want to save in QVD. How we can to the same.

SP NAME : usp_EPCM_Get_FinalPolish_Report_bck

Input Parameter :

@LotID Bigint,

@FromDate varchar(50),

@ToDate varchar(50),

@Diff varchar(50),

@colours varchar(50) ,

@clarity varchar(50) ,

@JewlexRapPriceDate datetime ,

@GIARapPriceDate datetime,

@VendorDate datetime

Please suggest me how we can do the same. I have tried from my end so many time but I could not able to fecth the data and can not store into QVD.

Thanks.

Re: Fetch the data from SP to QlikView with input parameter.

vinay_hg — Mon, 17 Nov 2014 11:53:48 GMT

when u are loading thourgh variable pass the parameter, i mean creat 5 variable save the input values pass the same to the procedure.

topic Fetch the data from SP to QlikView with input parameter. in QlikView

Fetch the data from SP to QlikView with input parameter.

Re: Fetch the data from SP to QlikView with input parameter.