Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Macro to open message box

Hi All,

I have an input field where a user can copy/paste Shipment ID's and click the 'Search' button to query the data on ShipmentID. However, if the user searches for a Shipment ID that does not exist, nothing happens. Instead, I would like a macro to run when the 'Search' action is executed that will open a message box telling you if one or more ShipmentIDs from the input box were not found in the field. Is this possible?

I have included an example file so that this question will make more sense. Thank you for the help.

1 Solution

Accepted Solutions
Not applicable

Re: Macro to open message box

keep this

7 Replies
Not applicable

Re: Macro to open message box

As an added challenge for you QlikView wizards, it would be ideal if the Message Box would say "The following ShipmentIDs were not found:" and then list the entered values not found in the field.

Not applicable

Re: Macro to open message box

hello , see my file. its should be what you are looking for

hello marchetto

Not applicable

Re: Macro to open message box

That's further than I got on this. I would still love to have it show which values were not found, but I don't know where to begin on that... Thanks for your help, Marco.

Not applicable

Re: Macro to open message box

keep this

Not applicable

Re: Macro to open message box

Awesome! Thank you very much!!

Not applicable

Re: Macro to open message box

figured.

So in this documet there isn't a input filed,but input box

Not applicable

Re: Macro to open message box

Doesn’t look like it recognizes when some parts are null and some aren’t though?

Community Browser