Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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


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.


SELECT FirstName








FROM Tbl_Psgr

WHERE FlightDate BETWEEN @StartDate AND @EndDate

ORDER BY FlightDate desc;