0 Replies Latest reply: Feb 19, 2013 3:23 PM by Saurabh Walke RSS

    Dynamic tables selection

      I use QlikView to connect to my SQL server! My tables are dated (eg: xyz_20130101)

       

      How do I select these tables dynamically based on the Interval stated by user?

       

      In other words, if a user selects Start_Date = '10/01/2012' and End_Date = '12/31/2012'... then the tables I want to use are xyz_20121001 and xyz_20130101 (end date table is always a day after end date)

       

      Any suggestions?

      Thanks in advance!