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??

      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;