I'm having an issue with understanding how Qlik is interpreting what I state. I need it to give me the a number depending on the year I filter for. If I filter for 2019 only, it should give me 2019 FBP. If I filter for any year but 2019, it should give me Net NU. And if I filter for 2019 and other years, it should give me 2019 FBP + Net NU.
The thing is that FBP changes to JU after 6 months and to NU at the end of the year. So based on our date, I would like FBP for 2019 but NU for other years and with the ability to filter for 2017 and 2018 or 2019 and 2017 or other dates but always going for NU if it passed and FBP if it is 2019.
My code looks like this but when I filter for 2019 and other years, it only shows NU and not the FBP: