Scripting question...Passing score, but not within due date

[#1]

I need help scripting/configuring a panel/chart with the following condition in QlikView.

Count the number of a given case Title that passed the benchmark score of 80, but NOT by the due date.

There are a number of data entries for a given case Title with varying scores and dates.

Variables/Conditions

Case = "Title"

Case Status = Completed

Case Score >= 80

Case Completed Date > Case Due Date

Case Due Date = "mm/dd/yyyy hh:mm:ss"

Case Completed Date = "mm/dd/yyyy hh:mm:ss"

Thanks for any help in advance. Please let me know if you have questions to help devise this.

Trista

[cristinapo]

Try

Count({$<[Case]={'Title'},[Case Score]={">=80"}, [Case Status]={'Competed'}, [Case Completed Date] ={$(> [Case Due Date])} >}  Case)

I'll have to double check the syntax in Qlikview tomorrow but I think these would be the filters.

[oscar_ortiz]

On the script side you can try something like this:

Table:

Load

     SomeFields,

     If(

          Case='Title' and

          [Case Status] = 'Completed' and

          [Case Score] >= 80 and

          [Case Completed Date] > [Case Due Date], 1, 0

     ) as [Passing Score]

On the UI side create an expression Sum( [Passing Score] )

Good luck

Oscar