New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!

Who Me Too'd this solution

alferrar
Contributor
Contributor

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

 

View solution in original post

Who Me Too'd this solution