Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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