Sum # of tasks between 2 date ranges

[#1]

Hi

I need to sum the number of tasks a person created between 2 dates, then assign them points for every 100 tasks created. For tasks created between 15/09/2017 and 30/09/2017 (inclusive) I want to award 5 points for every 100 tasks, and between 01/10/2017 and 15/10/2017 (inclusive) I want to award 10 points for every 100 tasks created.

I assume set analysis is required?

Thanks in advance!

Becs

[darrell_tobin]

Hi Rebecca,

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:

1. Create a dateid  for each date and use the dateid field in your set analysis instead.  Syntax is easier and it will work
2. Load an excel table that creates scores lookup for each date

e.g.

Date             Score

15/9/17            5

16/09/17          5

01/10/17          10

etc.

All you will have to do then is sum the Score value...