0 Replies Latest reply: Apr 26, 2012 1:10 PM by bireport RSS

    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;