https://community.qlik.com/t5/App-Development/Year-total-in-Monthly-Denominator/m-p/1560883#M40848 <P>Hello, I have a situation where I need the Year total to be the denominator for every month and Quarter but also for the year.&nbsp; I've been struggling with the set analysis required to do this.&nbsp; 3.8% is the correct number for the year total but I need the months to add up to 3.8%.&nbsp; Any help would be appreciated.</P><P>This got me close but it only put the desired amount in January and the Total.&nbsp; With nothing in Feb-Dec.</P><P>sum(aggr(sum({&lt;DATA_TYPE={'STAT'}&gt;}STATUTORY_WRITTEN_PREMIUM),Year))</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sample.jpg" style="width: 962px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8770iB7863DB3113F5445/image-size/large?v=v2&amp;px=999" role="button" title="Sample.jpg" alt="Sample.jpg" /></span></P> Sat, 16 Nov 2024 06:15:35 GMT carlcimino 2024-11-16T06:15:35Z https://community.qlik.com/t5/App-Development/Year-total-in-Monthly-Denominator/m-p/1560883#M40848 <P>Hello, I have a situation where I need the Year total to be the denominator for every month and Quarter but also for the year.&nbsp; I've been struggling with the set analysis required to do this.&nbsp; 3.8% is the correct number for the year total but I need the months to add up to 3.8%.&nbsp; Any help would be appreciated.</P><P>This got me close but it only put the desired amount in January and the Total.&nbsp; With nothing in Feb-Dec.</P><P>sum(aggr(sum({&lt;DATA_TYPE={'STAT'}&gt;}STATUTORY_WRITTEN_PREMIUM),Year))</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sample.jpg" style="width: 962px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8770iB7863DB3113F5445/image-size/large?v=v2&amp;px=999" role="button" title="Sample.jpg" alt="Sample.jpg" /></span></P> Sat, 16 Nov 2024 06:15:35 GMT https://community.qlik.com/t5/App-Development/Year-total-in-Monthly-Denominator/m-p/1560883#M40848 carlcimino 2024-11-16T06:15:35Z https://community.qlik.com/t5/App-Development/Year-total-in-Monthly-Denominator/m-p/1560890#M40849 <P>Should have been using the total command in my set analysis instead of Aggr().</P><P>sum(<U><STRONG>total&lt;Year&gt;</STRONG></U>{&lt;DATA_TYPE={'STAT'}&gt;}STATUTORY_WRITTEN_PREMIUM)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Solution.jpg" style="width: 637px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8771iF4BCDEFB3AF6C494/image-size/large?v=v2&amp;px=999" role="button" title="Solution.jpg" alt="Solution.jpg" /></span></P> Mon, 25 Mar 2019 16:33:58 GMT https://community.qlik.com/t5/App-Development/Year-total-in-Monthly-Denominator/m-p/1560890#M40849 carlcimino 2019-03-25T16:33:58Z