Hi,
In my QlikSense application future data also available. By default the application is showing current year and current month data. When I select previous year only it will show that full year data from Jan to Dec (it showing as expected). However when I select 2022 and month (Jan or Feb or Mar) it will show the data as expected, but when I select year 2022, it is showing 2022 full year data. I should show year to date data only in one of the Bar chart. Other charts and pivot tables should show future data as well in the application. it is only for year 2022 for previous years it should showing full year data. Please help to acheive. Please refer the attached file for my SET expression.
Values used in SET analysis:
vCurrentYear =Left(max(%Date.KEY), 4)
vCurrentPeriod =max(%Date.KEY)
vCurrentMonth =mid(vCurrentPeriod, 5, 2)
Note: when we create the dates we have the field called YTD and it has the value 1 for till today date and for future dates it is 0
