Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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!

Community Browser