KPI - Count and sum Total of filtered data

[FHG153]

New to Qlik

Looking to create a KPI measure to activate action to address over budget and overdue  information 

Data used eg

1)Date of planed completion 

2) Date project closed 

3)Budget of project

Filter requited

1)Date project closed is Null   = Valid open project 

2)Date of planed Invoice < date(now) = Project is late 

3) Budget  = Budget of projects

Result

The Budget value of the projects that are open and late

The count value of the projects that are open and late

eg screen shot is sheet created in Data studio to be created in Qlik

[lironbaram]

hi 

the easiest way will be something like 

sum(if(isnull([date project closed]) and [date of planed invoice]<today(),Budget))

and 

count (distinct  if(isnull([date project closed]) and [date of planed invoice]<today(),project))