I am quite new to Qulikview. I am trying to create a Calculation for the Year to Date. The Goal is that I can still choose the month and Year from the filter, so the Year to date is calculated accordingly. The fields that I have are Month Year and Salesamount. The Salesamount is aggregated on monthly bases.
I tried to flag the Month from starting of the year until today() with a 1 in the loadscript, but then I cannot choose the months from the filter anymore because it is fix in Set expression statement.