Refresh only on Sat

qlikuser222 — Thu, 18 Aug 2016 17:30:59 GMT

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

Re: Refresh only on Sat

vishsaggi — Thu, 18 Aug 2016 19:02:15 GMT

Try this:

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

Load *;

SQL Select etc..

topic Re: Refresh only on Sat in QlikView

Refresh only on Sat

Re: Refresh only on Sat