Discussion board where members can get started with QlikView.
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
but I cant seem to figure it out with the day count also
Can anyone please help ?
Go to Solution.
min([Open/Closed]='Open' and (today()-[Date reported to / noticed by COPs])>20)
Edit: Added missing (
Thanks John I stuck in a ( and it works perfect
Happy New yearA