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