Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Error in Set Modifier Expression


I am receiving an error for the following expression:

=Sum({1<CC_Date = {"$(='>=' & Date(WeekStart(Max(CC_Date)), 'M/D/YYYY') & '<=' & Date(WeekEnd(Max(CC_Date)), 'M/D/YYYY'))"}[Abandoned])

My goal is to show the sum of abandoned for the max week in the data.

1 Reply
MVP & Luminary
MVP & Luminary

Re: Error in Set Modifier Expression

Try this:

=Sum({1<CC_Date = {">=$(=Date(WeekStart(Max(CC_Date)), 'M/D/YYYY'))

                                      <=$(=Date(WeekEnd(Max(CC_Date)), 'M/D/YYYY'))"}>} [Abandoned])

- Marcus