topic Re: Alert message when Macro fails in QlikView

Alert message when Macro fails

OmarBenSalem — Wed, 25 Nov 2020 16:16:04 GMT

Hi community,

When we execute a macro and it fails,the per default thing that happens is that the macro script is shown.

My question now, is there a way, instead of this behaviour, a Message Box is shown (an alert) saying that the macro failed to execute? or/AND an email is sent saying that the MACRO FAILED TO EXECUTE?

Thank you a lot !

Re: Alert message when Macro fails

HirisH_V7 — Tue, 24 Oct 2017 09:30:06 GMT

Hi ,

You want to sent email means through QMC or just reload. As QMC will not execute macros.

Have a look into this,

Re: QVW to create bat file which contain the copy command for all the QVD's used in the QVW. Help on this!

HTH,

Hirish

Re: Alert message when Macro fails

srivastalans — Tue, 24 Oct 2017 10:03:58 GMT

Hi,

Create a dummy variable as vA in Variable Overview and go to Document Properties --> Triggers --> OnPostReload --> add actions (b4 Run Macro) --> Set Variable --> Variable = vA , Value = 1

Below Set Variable vA, add action Run Macro --> Macro Name = Check

Try this code in macro (Tools --> Edit Module),

Sub Check

If (ActiveDocument.Evaluate("=$(vA)"))=1 then

'Your Code

Set Var1 = ActiveDocument.Variables("vA")

Var1.SetContent "0",true

else

Msgbox("Macro Failed")

End If

end sub

Re: Alert message when Macro fails

OmarBenSalem — Tue, 24 Oct 2017 10:19:22 GMT

if I have this;

sub Distribute

bla bla

end sub

and then add :

Sub Check

If (ActiveDocument.Evaluate("=$(vA)"))=1 then

'//here is my code

sub Distribute

bla bla

end sub

'//////

Set Var1 = ActiveDocument.Variables("vA")

Var1.SetContent "0",true

else

Msgbox("Macro Failed")

End If

end sub

=> I have a syntax error !

How to surround my sub with the check sub?

Re: Alert message when Macro fails

srivastalans — Tue, 24 Oct 2017 10:25:32 GMT

Hi Omar,

Add your code without including Sub Distribute and end sub..

Re: Alert message when Macro fails

OmarBenSalem — Tue, 24 Oct 2017 11:21:26 GMT

That's really good ! and what if with the alert, I want to send an email just for me with the object : macro failure and a message: the macro has failed?

Re: Alert message when Macro fails

srivastalans — Tue, 24 Oct 2017 11:34:41 GMT

Hi Omar,

I want to work on that error message as mail to User.

Regards,

Sri

Re: Alert message when Macro fails

srivastalans — Tue, 24 Oct 2017 11:40:58 GMT

Check this Omar,

Better in else script you can add this,

https://community.qlik.com/thread/69476

Re: Alert message when Macro fails

OmarBenSalem — Tue, 24 Oct 2017 12:08:02 GMT

Great !