I am going to try and explain this the best that I can.
I have a structure that has an ID, a start date and an end date. The ID can have multiple start and end dates.
For example:
ID
Start
End
0001
1/1/2022
2/2/2022
0001
2/3/2022
3/3/2022
0001
3/4/2022
4/4/2022
0001
1/1/2024
2/2/2024
Now I have a few things I need to do with these dates.
I have written an expression to look for the dates within the next 365 days, which works fine. However, I also need to count how many dates are remaining regardless of if they are within the next 365 days. I am trying to use this expression:
I am still trying to figure out how QLIK data works, but it is my assumption that because my table is set to show the dates ending within the next year, when I try and count all of the start dates that are in the future, it only counts them within the next 365 days.
Additionally, I need to show the FINAL end date but I am having an issue using MAX. Once again, it is showing the final date within the 365 days, but not the final date for the ID.