Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ankit777
Specialist
Specialist

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
Partner - Specialist
Partner - Specialist

Load * from tableName where Month='January';

Not applicable

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!

tresesco
MVP
MVP

Month='January'

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

Not applicable

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

LOAD * FROM SOURCEQVD.qvd (qvd)

Where Match(Month,'January') ;