Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Community Browser