Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

Re: Macro to open message box

7 Replies
Highlighted
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.

Highlighted
Not applicable

Re: Macro to open message box

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

hello marchetto

Highlighted
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.

Highlighted
Not applicable

Re: Macro to open message box

Highlighted
Not applicable

Re: Macro to open message box

Awesome! Thank you very much!!

Highlighted
Not applicable

Re: Macro to open message box

figured.

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

Highlighted
Not applicable

Re: Macro to open message box

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