topic Alert condition in QlikView

Alert condition

Wed, 02 Feb 2011 06:57:18 GMT

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?

Alert condition

Wed, 02 Feb 2011 07:31:33 GMT

try to reload the attached document

you can use this blog as your guide:

http://qlikviewnotes.blogspot.com/2010/09/monitoring-reload-schedule.html

Alert condition

Wed, 02 Feb 2011 07:41:06 GMT

Can we do this without selecting any Country?

Alert condition

Wed, 02 Feb 2011 08:05:18 GMT

I haven't tried it yet i am still a newbie in qlikview..

Alert condition

Wed, 02 Feb 2011 09:58:12 GMT

I think its possible..

you should have an flag that will be your indicator whether that country's Sales is less than 3000..

e.g (Condition in Alert)

1 = Yes

0 = No

=Sum(SalesFlag)>0

Alert condition

Thu, 03 Feb 2011 01:13:07 GMT

check this new file...sorry if the script is not that clean.

i created a new field watawat as your flag...

Alert condition

Thu, 03 Feb 2011 06:07:18 GMT

I have solved this by creating a bookmark which contains the Countries which are having sales less than 3000 and used that bookmark in the alert.

Alert condition

Thu, 03 Feb 2011 06:14:15 GMT

Good for you...

Alert condition

Fri, 01 Apr 2011 16:40:01 GMT

HI Shans,

Thanks so much for this. Can you explain exactly how you made this bookmark?

Thanks,

Matt

Alert condition

Mon, 04 Apr 2011 01:30:14 GMT

Go to Bookmarks > Add Bookmark

Alert condition

Mon, 04 Apr 2011 01:33:49 GMT

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

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

Alert condition

Tue, 05 Apr 2011 06:24:25 GMT

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.

Alert condition

Sat, 16 Apr 2011 20:02:22 GMT

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.

Alert condition

rwunderlich — Sun, 17 Apr 2011 03:18:23 GMT

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.

Alert condition

Sun, 17 Apr 2011 17:42:23 GMT

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!

Alert condition

rwunderlich — Mon, 18 Apr 2011 05:02:15 GMT

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.

Alert condition

Fri, 22 Apr 2011 21:13:49 GMT

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

I would really appreciate it!

Alert condition

rwunderlich — Fri, 22 Apr 2011 21:46:35 GMT

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

Alert condition

Thu, 17 Nov 2011 13:33:59 GMT

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

Re: Alert condition

rwunderlich — Thu, 24 Nov 2011 00:09:10 GMT

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