Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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.
In forum I found this solution:
sum({<Year=, Month=,CalDate= {'>=$(=YearStart(Max(CalDate)))<=$(=Max(CalDate))'}>}NetCount)
Anyone knows how to adapt it to my case or can help me with an own solution?
Thank you!!