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!