topic SV:Close QlikView from Script in QlikView

Close QlikView from Script

Tue, 12 Apr 2011 09:24:53 GMT

Hello,

how can i close QlikView from Load script?

I try this.

Macro Module


function quit2()
 Application.Quit
 and
 ActiveDocument.GetApplication.Quit
end function

Load Script


 let cl = quit2();

that does not work

Thanks!!!

Close QlikView from Script

Tue, 12 Apr 2011 10:59:34 GMT

Try this,

function quit2()
ActiveDocument.GetApplication.Quit
end function

Close QlikView from Script

siva_boggarapu — Tue, 12 Apr 2011 12:33:00 GMT

Hi,

try Exit Script . I think it may work

SV:Re: Close QlikView from Script

gandalfgray — Tue, 12 Apr 2011 12:45:20 GMT


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.

SV:Close QlikView from Script

gandalfgray — Tue, 12 Apr 2011 13:26:30 GMT

Add an OnPostReload trigger calling your quit2 macro:

Re: SV:Close QlikView from Script

Tue, 28 May 2013 09:48:37 GMT

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

Re: SV:Close QlikView from Script

flipside — Tue, 28 May 2013 10:05:25 GMT

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

Re: SV:Close QlikView from Script

Tue, 28 May 2013 10:15:08 GMT

This will work perfectly for me.

Thank you!!