Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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;

0 Replies