I've followed the tutorial from Henric to create an AsOfMonth calendar that can be used to create a YTD chart:
https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130
This works perfect with a sum expression, but it doesn't work with an Aggr function like:
sum(aggr(max({<Metric={'Facebook'}>} Value), Social_PostID, Social_Is_Dark_Post))
When i apply this formula in a table with as dimension 'AsOfMonth', it will only give a result on June.
What am i doing wrong? 🙂