Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ankit777
Valued Contributor

Conditionally reloading a table

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

4 Replies
brijesh1991
Contributor III

Re: Conditionally reloading a table

Load * from tableName where Month='January';

Not applicable

Re: Conditionally reloading a table

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!

MVP
MVP

Re: Conditionally reloading a table

Month='January'

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

Not applicable

Re: Conditionally reloading a table

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

LOAD * FROM SOURCEQVD.qvd (qvd)

Where Match(Month,'January') ;

Community Browser