topic Re: Alert Multiple Criteria in QlikView

Alert Multiple Criteria

Fri, 30 Dec 2011 13:17:02 GMT

Hi Guys

I have an Alert on the QV Dashboard that I want based on the following Chart,

Basically I wish it to fire when field Open/Closed is = 'Open' AND

Diff Between Noticied and Closed > '20' --- The Calculation for this field is

=if(isnull([Date Closed]),sum(today()-[Date reported to / noticed by COPs]),sum([Date Closed]-[Date reported to / noticed by COPs]))

I can get it to fire based on the open/close using

sum

(if([Open/Closed] ='Open',1))>

but I cant seem to figure it out with the day count also

Can anyone please help ?

Thanks

johnw — Fri, 30 Dec 2011 18:22:30 GMT

Maybe this?

min([Open/Closed]='Open' and (today()-[Date reported to / noticed by COPs])>20)

Edit: Added missing (

Tue, 03 Jan 2012 09:17:31 GMT

min([Open/Closed]='Open' and (today()-[Date reported to / noticed by COPs])>20)

Thanks John I stuck in a ( and it works perfect

Happy New year
A