topic Re: SUM IF with AGGREGATE Function in QlikView https://community.qlik.com/t5/QlikView/SUM-IF-with-AGGREGATE-Function/m-p/132941#M760119 <HTML><HEAD></HEAD><BODY><P>Are you looking for this? If not can you elaborate a little more please on what exactly you are trying to calculate. </P><P></P><P>= IF(Status= 'Eligible', Sum({&lt; Status= {'Out Of Contract'} &gt;} Revenue)/COUNT(member_id))</P></BODY></HTML> Wed, 29 Aug 2018 16:28:01 GMT vishsaggi 2018-08-29T16:28:01Z SUM IF with AGGREGATE Function https://community.qlik.com/t5/QlikView/SUM-IF-with-AGGREGATE-Function/m-p/132940#M760118 <HTML><HEAD></HEAD><BODY><P>Hello - I am new to Qlik and need to do a IF and aggregate function. Is this possible?</P><P></P><P>This is what I have but get an ERROR:</P><P></P><P>SUM(IF(Status= 'Eligible',IF(Status= 'Out Of Contract',(SUM(Revenue)/COUNT(member_id)))))</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/SUM-IF-with-AGGREGATE-Function/m-p/132940#M760118 Anonymous 2020-11-25T16:16:04Z Re: SUM IF with AGGREGATE Function https://community.qlik.com/t5/QlikView/SUM-IF-with-AGGREGATE-Function/m-p/132941#M760119 <HTML><HEAD></HEAD><BODY><P>Are you looking for this? If not can you elaborate a little more please on what exactly you are trying to calculate. </P><P></P><P>= IF(Status= 'Eligible', Sum({&lt; Status= {'Out Of Contract'} &gt;} Revenue)/COUNT(member_id))</P></BODY></HTML> Wed, 29 Aug 2018 16:28:01 GMT https://community.qlik.com/t5/QlikView/SUM-IF-with-AGGREGATE-Function/m-p/132941#M760119 vishsaggi 2018-08-29T16:28:01Z