Load all data into Qlikview on 1st day of the month but only load 1 table there rest of the data

[elaineng]

I have a qlikview report which have 3 tables (sales, customer account, aging reason). 

For 1st day of the month, I would like to  have 3 tables updated, but the rest of the day, I only wants aging reason to be load/update.

Is this doable?

sales:

Load *;

SQL Select * from sales;

CustomerAccount:

Load *;

SQL Select from customers;

agingreason:

Load *;

SQL Select from agingreason;

[Vegar]

[Removed duplicate]

[Vegar · Accepted solution]

If you can settle with creating a QVD file for sales, then you can do this

If day(today()=1 then
Sales:
Load *;
SQL Select * from sales;
Store Sales into Sales.and (QVD);

CustomerAccount:
Load *;
SQL Select from customers;
Store CustomerAccount into CustomerAccount.qvd (QVD);
Else
Load * from Sales.qvd (QVD);
Load * from CustomerAccount.qvd (QVD);
End if
agingreason:
Load *;
SQL Select from agingreason;