topic Nested Aggregation and CountIf together in QlikView

topic Nested Aggregation and CountIf together in QlikView https://community.qlik.com/t5/QlikView/Nested-Aggregation-and-CountIf-together/m-p/690280#M475250 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I have written a set expression which calculates a measure for me.</P><P></P><P>calculation:</P><P>=(Sum(A)+(sum({<Account_Id={'4'}>}A)))/(sum({<Account_Id={'2'}>}A))         </P><P></P><P>I need to check and count values of this measure that are greater than 0.95 </P><P></P><P>How can I achive this ?</P><P></P><P>Thanks,</P><P>Sailee</P></BODY></HTML> Thu, 31 Jul 2014 12:13:39 GMT 2014-07-31T12:13:39Z Nested Aggregation and CountIf together https://community.qlik.com/t5/QlikView/Nested-Aggregation-and-CountIf-together/m-p/690280#M475250 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I have written a set expression which calculates a measure for me.</P><P></P><P>calculation:</P><P>=(Sum(A)+(sum({<Account_Id={'4'}>}A)))/(sum({<Account_Id={'2'}>}A))         </P><P></P><P>I need to check and count values of this measure that are greater than 0.95 </P><P></P><P>How can I achive this ?</P><P></P><P>Thanks,</P><P>Sailee</P></BODY></HTML> Thu, 31 Jul 2014 12:13:39 GMT https://community.qlik.com/t5/QlikView/Nested-Aggregation-and-CountIf-together/m-p/690280#M475250 2014-07-31T12:13:39Z