Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.


YTD calculation - Aggr function - As of calendar

I've followed the tutorial from Henric to create an AsOfMonth calendar that can be used to create a YTD chart:


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? 🙂