I need to do an YTD comparison in Qlik Sense. So far I have created a flag for the current year and the previous year and using the flag I am comparing the current year sales with the previous one. If I select specific dates it will work again.
Now my question is the following - I have full 2020 data but for 2021 I have until the last day of the previous month (30th of October) so if I compare 2021 with 2020, I am actually comparing unfinished year (2021) with a finished one (2020) and this should not be the case.
How can I make Qlik understand that I want to compare the current year with the previous year, but only until the date I have available for the current year (in this case 30th of October).