topic Scripting question...Passing score, but not within due date in QlikView

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

Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 09 Oct 2017 19:33:32 GMT

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 — Mon, 09 Oct 2017 19:35:42 GMT

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