Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
it worked this way:
sum (if( week<= max( total aggr(if(year=2020,week),week,year)) and year=2020 , Pratiche))
the trick was "total". The "total" makes it useless the aggr() so the above become the same of:
sum (if( week<= max( total if(year=2020,week)) and year=2020 , Pratiche))
which is a wiser method to obtain what I needed
I don't really get it anyway, I mean, it wasn't a true nested aggregation from the beginning as it is working on the condition, and not the data and anyway I was using aggr().
Oh, well, anyway, solved. Thanks