Group dates in future, backlog and today

[vkal12]

Hello Community, 

I am pretty new to Qlik Sense and I have the following challenge: 

I would like to group a date field in the groups future, past and today based on the dates. This means, that every date that is smaller than today belongs to the past, today is today and the future is every date that is greater than today. 

Based on those groups I would like to calculate multiple KPI. Can anyone help me on how to group those dates? Everything that I tried out does not seem to work properly.

Thank you very much!

[marcus_sommer]

You may use something like this within the script:

pick(match(sign(Date - today()), -1, 0, 1), 'past', 'today', 'future') as DateGroup 

and then you could filter on this field or using it as dimension within a chart.

- Marcus