Alert not working

[bobbydave]

Attached is my qvw.

I have it working if you look at sheet 1.

The bar chart shows a list of countries and their values.

In the text box beside it, I have an expression to show countries over 0.2 to appear.

In my alert, I've the same expression to show only anything over 0.2 and in the message text, it will appear to show the countries over 0.2.

However, the alert doesn't seem to work.

Any ideas?

[lironbaram · Accepted solution]

hi

have a look at the attach example

i changed the alert condition to count if there are countries under threshold

and changed the message to include only countries under threshold

your condition checked the overall result not by country level

[bobbydave]

Thanks Liron

[bobbydave]

Liron,

Could I ask you one more question.

I am trying to add [Control Description] also so that the Country and [Control Description] appear.

Right now, its showing an overall Country score so it is only giving me 4 countries when in fact, i should have something resembling

[Control Description]    Country

  Claims Registered      Columbia      is over threshold

   Case Measures         Columbia      is over threshold

  Policy New Business  Columbia      is over threshold           

[lironbaram]

hi

have a look at the attach example

now it evaluate the condition per control and country

i also modified the alert message