topic Re: Is it possible to create an alert in a script? in QlikView

Is it possible to create an alert in a script?

Tue, 21 Apr 2015 12:07:18 GMT

Hello,

Actually, I try to put an alert in my script. For example, when my script has to LOAD every files from my directory and if one is missing I want to put a message to warn people.

I know that I have to use " if " to make a condition, but there's a way to make a display ?

Regards

Re: Is it possible to create an alert in a script?

datanibbler — Tue, 21 Apr 2015 12:10:25 GMT

Hi,

you can use the Msgbox() function - but only if the script is being run locally as it will have to be confirmed before the script continues executing.

Re: Is it possible to create an alert in a script?

Marcellino_Groothof — Tue, 21 Apr 2015 12:19:59 GMT

Hi,

Try this as a example in script:

if(Clientnr=peek(Clientnr) and Retourrecht <> peek(Retourrecht),'Retre gewijzigd') as Alerts_Retourrecht,
if(Clientnr=peek(Clientnr) and Dagen=peek(Dagen) and (Levering > 200 and peek(Levering) <= 200),'Lev > 200') as Alerts_Levering,
if(Clientnr=peek(Clientnr) and Tariefcode <> peek(Tariefcode),'Tarief gewijzigd','Tarief ongewijzigd') as Alerts_Tariefcode

After the reload u can use it in a listbox.

Regards,

Marcellino