Hi,
I'm new to QlikSense, and I'm trying to make a chart that we had in another BI Tool. In order to do this, I need to calculate the Sum of the Net Amount for the year separated out by month, but only for the current year. So this will require 12 different calculations and be set up in a table so that management can see each month listed at the top with the Sales team / person to the left and show the achieved amount for each month for the whole year.
To calculate September's Net Revenue, I used this:
MONEY(Sum({$<Year={2023}>*1<Month={'Sep'}>}
[Net Amount]*IF(ISNULL([Split Percent]), 1, [Split Percent])), '$#,##0.00')
The calculation above works to give what I need (and gives me the formatting too), however, I cannot just replace the '2023' with YEAR(Today()) as it throws an error. How can I get this expression to allow me to have it dynamically pull in the current year where '2023' is currently hardcoded (other charts in the dashboard show both past performance and forecasts so I need to do this at the chart level)?
