Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
twanqlik
Contributor

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:

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