How can I call the TSQL Query with Date range parameters in Qlik View??

Wed, 25 Apr 2012 21:44:22 GMT

Hi,

I've a simple TSQL query with Date range parameters that runs fine in SQL Server Management studio and SSRS. Now, I'm trying to use this query in QlikView to create a report. I'm new to QlikView and just couldn't find a way to get the dataset from the below mentioned query. I believe I must be missing out something here.

Any kind is help and suggestion is really appreciated.

Thanks.

SELECT FirstName

,LastName

,PsgrID

,TktNbr

,FlightDate

,DeptCity

,TktAmount

,SeatNbr

FROM Tbl_Psgr

WHERE FlightDate BETWEEN @StartDate AND @EndDate

ORDER BY FlightDate desc;

topic How can I call the TSQL Query with Date range parameters in Qlik View?? in QlikView

How can I call the TSQL Query with Date range parameters in Qlik View??