Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What script should I use if I want a table to be reloaded only when certain conditions are satisfied.
for example, Month='January'
Load * from tableName where Month='January';
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!
Month='January'
Is this month taken from system , or is it coming from any data source? Can you elaborate a bit more?
If the source is QVD or txt or excel file: use Match function;
LOAD * FROM SOURCEQVD.qvd (qvd)
Where Match(Month,'January') ;