Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishpalkar
Creator III
Creator III

Auto turn on / off Script

Hi Experts

I am doing following method in my script.

I have created 5 script tabs for creation of QVD. I have created script file (.QVS) and exported it on my shared drive.

I am using following If condition to turn on off script every month

set RUN_Tab1 =1;

set RUN_Tab2 =1;

set RUN_Tab3 =1;

set RUN_Tab4 =1;

set RUN_Tab5 =1;

using If condition I am controlling the script run. IF RUN_Tab1=1 then XXX XXX EndIF

When set RUN_Tab1 =0 it will simply skip that script and move to next one respectively..

Every month on 15th we need to turn on

set RUN_Tab3 =1;

set RUN_Tab4 =1;

and after refresh turn off like this..

set RUN_Tab3 =0;

set RUN_Tab4 =0;

Is there any way I can automatically turn on / off this without changes to shared drive script file?

Thanks in advance...

1 Reply
rubenmarin

Hi Ashish, have you tried to use LET to check the day before assigning 1 or 0?, ie:

LET RUN_Tab3 = If(Day(Today())=15, 1, 0);