Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
how can i close QlikView from Load script?
I try this.
Macro Module
function quit2()
Application.Quit
and
ActiveDocument.GetApplication.Quit
end function
let cl = quit2();
that does not work
Thanks!!!
Try this,
function quit2()
ActiveDocument.GetApplication.Quit
end function
Hi,
try Exit Script . I think it may work
Siva wrote:
Hi,
try Exit Script . I think it may work<div></div>
exit script in the load script just exits the load script. It does not quit the application.
I maybe after the same thing here and it is not looking possible. But what I need is within the script (Not Macro) to reload on a Monday, Tuesday and not Wednesday onwards.
So seuodo =
IF Date(Today(),'WWW') = 'Mon' then
Load blah blah blah
ElseIF <> Mon or Tue for that matter
Close Qlikview but keep data as it was prior to this session.
( I see Exit Script, but that removes the old data and I end up with a blank doc)
Is there a suggestion not using Publisher or a batch file (Which is what I have had to do using windows Scheduler - which is rubbish)??
Help appreciated
Peter
Hi Peter,
I use a "Control" .qvw document to manage my multiple and infrequent reloads. You can set the control document to reload every day at the desired time and check the day in an 'if' statement. If the script is true, then force the control document to FAIL by using something like this ...
If (day(today()) = 'Mon') then
Load nonexistant field from nonexistant table;
EndIf;
When the if statement is false, the control document succeeds, but when it is true it fails. You then set up your target document to run on the failure state of the control document. It won't refresh when the control document succeeds. Your admin just need to know that the Control doc will sometimes show a failure state by design.
Hope this helps.
flipside
This will work perfectly for me.
Thank you!!