topic Text Box Expression to show last week Average - Error In Set Modifier in QlikView

Text Box Expression to show last week Average - Error In Set Modifier

Wed, 29 Jun 2016 14:24:47 GMT

Hello,

I am experiencing an error in the set modifier for the following Text Element

=num(Avg({1<CC_Date={">=$(=Date(WeekStart(Max(CC_Date), 'M/D/YYYY'))<=$(=Date(WeekEnd(Max(CC_Date)), 'M/D/YYYY'))"}>} ([FCR % (=>80%)])), '#.##%')

My Date field is CC_Date

And I want to who the average for the week prior of the field [FCR % (=>80%)]

tamilarasu — Wed, 29 Jun 2016 15:46:23 GMT

Linsey,

Try this,

=num(Avg({1<CC_Date={">=$(=Date(WeekStart(Max(CC_Date)), 'M/D/YYYY'))<=$(=Date(WeekEnd(Max(CC_Date)), 'M/D/YYYY'))"}>} [FCR % (=>80%)]), '#.##%')

Wed, 29 Jun 2016 16:09:39 GMT

Thank you!