Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Drop Table on Partial reload only.

Hi, ive got a qlikview project that loads a table from a ODBC database, then that loaded table contains names of other tables.

So the main table is loaded on the report, after that the user chooses a table and does a partial reload, so the main table stays unchanged and he can now load any other sub table, my problem is, the user Loads subtable1, everything fine, when he now loads subtable 2 with different field names it will show subtable one and subtable2, what i want to do is Drop subtable1 when the user presses partial reload only.

My script is:

ODBC CONNECT TO QV (XUserId is ITJSCYdNTDdOGZVMTTLA, XPassword is MLbTHYVOODdeWTROTRFA);

Select * from qc_table;

Replace select * from $(var1);

Thanks

0 Replies