Dates in set analysis is a nightmare, the syntax is difficult and Qlik sometimes gets confused as to if the field is a date or not.
Two work arounds below:
- Create a dateid for each date and use the dateid field in your set analysis instead. Syntax is easier and it will work
- Load an excel table that creates scores lookup for each date
All you will have to do then is sum the Score value...