Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

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

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;