topic Re: Conditionally reloading a table in QlikView

Conditionally reloading a table

ankit777 — Tue, 07 Jan 2014 05:17:18 GMT

What script should I use if I want a table to be reloaded only when certain conditions are satisfied.
for example, Month='January'

brijesh1991 — Tue, 07 Jan 2014 05:25:08 GMT

Load * from tableName where Month='January';

Tue, 07 Jan 2014 05:26:31 GMT

You can try using partial reload.

For this, you need to have "ADD" or "REPLACE" before the load or select statement.

Check Qlikview help and you will find exact details.

Hope this helps!

tresB — Tue, 07 Jan 2014 05:26:45 GMT

Month='January'

Is this month taken from system , or is it coming from any data source? Can you elaborate a bit more?

Tue, 07 Jan 2014 05:26:58 GMT

If the source is QVD or txt or excel file: use Match function;

LOAD * FROM SOURCEQVD.qvd (qvd)

Where Match(Month,'January') ;