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.
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.