topic Dynamic tables selection in QlikView https://community.qlik.com/t5/QlikView/Dynamic-tables-selection/m-p/451817#M486870 <HTML><HEAD></HEAD><BODY><P>I use QlikView to connect to my SQL server! My tables are dated (eg: xyz_20130101)</P><P></P><P>How do I select these tables dynamically based on the Interval stated by user? </P><P></P><P>In other words, if a user selects <STRONG>Start_Date = '10/01/2012'</STRONG> and <STRONG>End_Date = '12/31/2012'</STRONG>... then the tables I want to use are <STRONG>xyz_20121001</STRONG> and <STRONG>xyz_20130101</STRONG> (<SPAN style="text-decoration: underline;">end date table is always a day after end date</SPAN>)</P><P></P><P>Any suggestions? </P><P>Thanks in advance! </P></BODY></HTML> Tue, 19 Feb 2013 20:23:21 GMT 2013-02-19T20:23:21Z Dynamic tables selection https://community.qlik.com/t5/QlikView/Dynamic-tables-selection/m-p/451817#M486870 <HTML><HEAD></HEAD><BODY><P>I use QlikView to connect to my SQL server! My tables are dated (eg: xyz_20130101)</P><P></P><P>How do I select these tables dynamically based on the Interval stated by user? </P><P></P><P>In other words, if a user selects <STRONG>Start_Date = '10/01/2012'</STRONG> and <STRONG>End_Date = '12/31/2012'</STRONG>... then the tables I want to use are <STRONG>xyz_20121001</STRONG> and <STRONG>xyz_20130101</STRONG> (<SPAN style="text-decoration: underline;">end date table is always a day after end date</SPAN>)</P><P></P><P>Any suggestions? </P><P>Thanks in advance! </P></BODY></HTML> Tue, 19 Feb 2013 20:23:21 GMT https://community.qlik.com/t5/QlikView/Dynamic-tables-selection/m-p/451817#M486870 2013-02-19T20:23:21Z