3 Replies Latest reply: Dec 3, 2014 3:30 AM by Mohammed Ashfaq Ali RSS

    How to Pass Dynamic Parameters from QlikView Tables or List Box back to the SQL Query in Script Window ?



      I was working on the below queries

      As the first query loads the Dates into QlikView from where user should be able to select the dates on which the SP need to execute and give the result set.


      SQL Select Date as StartDate, Date as EndDate from Dim_Date where Calendar_Year in ('2013','2014');


      SQL EXEC ('[dbo].[usp_rpt_MonthlyRevenue_bySource] "$(vStartDate)", "$(vEndDate)"  ' )


      Can any one let me know the process to pass those values using variables.


      Thanks in Advance.