https://community.qlik.com/t5/QlikView/YTD-calculation-Aggr-function-As-of-calendar/m-p/1591765#M443605 <P>I've followed the tutorial from Henric to create an AsOfMonth calendar that can be used to create a YTD chart:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130</A></P><P>This works perfect with a sum expression, but it doesn't work with an Aggr function like:</P><P>sum(aggr(max({&lt;Metric={'Facebook'}&gt;} Value), Social_PostID, Social_Is_Dark_Post))</P><P>When i apply this formula in a table with as dimension 'AsOfMonth', it will only give a result on June.</P><P>What am i doing wrong? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P> Thu, 13 Jun 2019 16:37:51 GMT twanqlik 2019-06-13T16:37:51Z https://community.qlik.com/t5/QlikView/YTD-calculation-Aggr-function-As-of-calendar/m-p/1591765#M443605 <P>I've followed the tutorial from Henric to create an AsOfMonth calendar that can be used to create a YTD chart:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130</A></P><P>This works perfect with a sum expression, but it doesn't work with an Aggr function like:</P><P>sum(aggr(max({&lt;Metric={'Facebook'}&gt;} Value), Social_PostID, Social_Is_Dark_Post))</P><P>When i apply this formula in a table with as dimension 'AsOfMonth', it will only give a result on June.</P><P>What am i doing wrong? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P> Thu, 13 Jun 2019 16:37:51 GMT https://community.qlik.com/t5/QlikView/YTD-calculation-Aggr-function-As-of-calendar/m-p/1591765#M443605 twanqlik 2019-06-13T16:37:51Z