Refresh only on Sat

[qlikuser222]

Hi All,

I have a requirement where i should refresh a particular table in QVW only on sat and rest all tables everyday.

Currently  i am managing refresh manually and want to automate it.

Example

Set TableXXX_Refresh = 1;

IF TableXXX_Refresh = 1 then

Load *;

SQL Select etc..

I am managing the above code manually, by switching TableXXX_Refresh between 1 and 0. I want to automate it and want to run the TableXXX_Refresh only on Sat.

Thanks

[vishsaggi · Accepted solution]

Try this:

IF( WeekDay(Today()) = 'Sat') Then

Load *;

SQL Select etc..