Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Alert Multiple Criteria

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))>

0

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

Can anyone please help ?

Thanks

Compliance.bmp

1 Solution

Accepted Solutions
MVP
MVP

Re: Alert Multiple Criteria

Maybe this?

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

Edit: Added missing (

2 Replies
MVP
MVP

Re: Alert Multiple Criteria

Maybe this?

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

Edit: Added missing (

Not applicable

Re: Alert Multiple Criteria

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