Alert condition

[#1]

Hi,

I need to check the sales of each country and if any of the country has sales less 3000 then a message should be displayed.

How to do this using alerts?

[#2]

you can also activate that alert without creating a bookmark...

just check the All Clear checkbox beside the Bookmark dropdown..

[#3]

Hi,

In "Country" list box, I have searched for the countries which are having sales less than 3000 and I have saved those selections in a bookmark.

[#4]

Question - the bookmark you created has pre-selected countries based on current data.

When data is reloaded, wouldn't the bookmark still point to the previously selected countries?

If so, this would present incorrect alert. Bookmart seems like wouldn't work in this instance unless there's a dynamic way to select values.

[rwunderlich]

The selection was made using a search expression. The search expression will be revaluated with the current data each time the bookmark is applied. So no, the bookmark is not tied any countries and it is dynamic.

[#6]

Thanks. However, I'm unable to recreate this dynamic bookmark.

Question - In the attached qvw, how do I edit the bookmark? Under Bookmarks --> More --> I can only browse the existing booking, but cannot see how the Bookmark was created so I can do the same thing with an expression in the Bookmark.

Your help is appreciated!

[rwunderlich]

You can't directly edit a bookmark. To "modify" an existing bookmark.

1. Apply the bookmark.
2. Make additional selections or replace selections.
3. Use menu Bookmark, Replace bookmark to update.

You create the dynamic search conditions by using standard QV search. For example, click on the If you don't have a listbox. dropdown or other searchable object, then create a temporary listbox to create the bookmark. For example,

1. Create a Country listbox.
2. Click the listbox caption and type "=sum(Sales)<1500" (without the quotes). This expression will now appear in your current selections.
3. Save the bookmark and delete the listbox.

[#8]

Can anyone give me a pointer on this dynamic bookmark creation?

I would really appreciate it!

[rwunderlich]

See my previous post in this thread. A "dynamic bookmark" is really just selections that are made using a search expression.

[#10]

Hi,

I also try to achieve this...

so I created an bookmark as you suggested. But how do I need to define the Alert if I want to get an email for each country with sales less than 3000? The only alert that works for me is when I do an aggregation on the whole document (or an selection). but I need it per country.

Thanks a lot in advance,

Martin

[rwunderlich]

The search expression in the bookmark is something like:

=Country=Sales<3000

and then the alert condition is:

=GetPossibleCount(Country) > 1

-Rob

http://robwunderlich.com