topic Alert not working in QlikView

Alert not working

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 03 Jan 2017 10:26:26 GMT

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 — Tue, 03 Jan 2017 10:34:01 GMT

Thanks Liron

bobbydave — Tue, 03 Jan 2017 13:30:12 GMT

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 — Tue, 03 Jan 2017 14:08:25 GMT

have a look at the attach example

now it evaluate the condition per control and country

i also modified the alert message