Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with expression

Need help with writing an expression!

I'm trying to create a dashboard to show KPI targets, and one of them is to messure actual completion dates against SLA completion date for work orders.

I need to count all the work orders where the Date Finished is less than the Date Escalated for Completion

Ultimately this would be to compare to a count of all completed work orders to messure against the 70% KPI target.

Couple of things I need to cater for within the expression:  A work order could have multiple engineer visits, the Date Finished field is from the time record of each engineer visit, so it is the latest engineer visit we are using in the KPI against the SLA completion date for the work order.  So I'm using "max([Date Finished]) to get this - if this is the correct or best way to go about this!!!

So far i've tried the following expression (in a text object), which I know doesn't work, but its a starter to try show what I'm doing:

=count(DISTINCT{<max([Date Finished])<[Date of Completion Escalation]>},[Work Request Code])

Any ideas how to get the right calculation/expression???

Thanks

Dan

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

=count(DISTINCT if ([Date of Completion Escalation] > aggr({1} max([Date Finished]), [Work Request Code]), [Work Request Code]))

View solution in original post

5 Replies
sunny_talwar

Try this, I have not tested it, but I think it should work:

=Count(DISTINCT{<[Date Finisted] = {'=Max([Date Finished])<[Date of Completion Escalation]'}>} [Work Request Code])


Best,

Sunny

sunny_talwar

Actually this may not work. Try this:

=Count(DISTINCT If(Max([Date Finished]) < [Date of Completion Escalation], [Work Request Code]))

Best,

Sunny

Not applicable
Author

Tried, still gives me "Error in expression" and no value in text object!!

Peter_Cammaert
Partner - Champion III
Partner - Champion III

=count(DISTINCT if ([Date of Completion Escalation] > aggr({1} max([Date Finished]), [Work Request Code]), [Work Request Code]))

Not applicable
Author

Seems to work, thanks!