topic Re: Multiple Nested Aggregations in Alternate State in QlikView https://community.qlik.com/t5/QlikView/Multiple-Nested-Aggregations-in-Alternate-State/m-p/1322359#M821962 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample to check this out?</P></BODY></HTML> Tue, 01 Aug 2017 02:31:28 GMT sunny_talwar 2017-08-01T02:31:28Z Multiple Nested Aggregations in Alternate State https://community.qlik.com/t5/QlikView/Multiple-Nested-Aggregations-in-Alternate-State/m-p/1322358#M821961 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>I am trying to compute an aggregation of a monthly count divided by another monthly count in alternative state. The two equations compute correctly before I try to divide, but the division is calculating correctly. Is there something that I am missing? </P><P></P><P>Thank you in advance!</P><P></P><P>=Sum({[Curr]&lt;[Region]=$::[Region], [Primary Cost Center]=$:: [Primary Cost Center]&gt;}Aggr(Count({[Curr]&lt;[Region]=$::[Region], [Primary Cost Center]=$:: [Primary Cost Center]&gt;}Distinct(If(CancellationStatus='On-Assignment Cancellation' and DateType='CancellationDate', [Contractor ID]))),MonthYear))</P><P>/</P><P>Sum({[Curr]&lt;[Region]=$::[Region], [Primary Cost Center]=$:: [Primary Cost Center]&gt;}Aggr(Count({[Curr]&lt;[Region]=$::[Region], [Primary Cost Center]=$:: [Primary Cost Center]&gt;}Distinct(if(DateType='OADate', [Contractor ID])))*.9,MonthYear))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Multiple-Nested-Aggregations-in-Alternate-State/m-p/1322358#M821961 Anonymous 2020-11-25T16:16:04Z Re: Multiple Nested Aggregations in Alternate State https://community.qlik.com/t5/QlikView/Multiple-Nested-Aggregations-in-Alternate-State/m-p/1322359#M821962 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample to check this out?</P></BODY></HTML> Tue, 01 Aug 2017 02:31:28 GMT https://community.qlik.com/t5/QlikView/Multiple-Nested-Aggregations-in-Alternate-State/m-p/1322359#M821962 sunny_talwar 2017-08-01T02:31:28Z