Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))