topic Re: Help with Expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-Expression/m-p/1305552#M406421 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><STRONG>Count(ID)/Count(TOTAL ID)</STRONG></P></BODY></HTML> Wed, 29 Mar 2017 19:30:17 GMT sunny_talwar 2017-03-29T19:30:17Z Help with Expression https://community.qlik.com/t5/QlikView/Help-with-Expression/m-p/1305550#M406419 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Field Name: ID</P><P>Expression needed: Count(ID) / Sum[Count (ID)]</P><P></P><P>Not able to get this expression work. Can you please help me with this?</P><P></P><P>Thank you </P></BODY></HTML> Wed, 29 Mar 2017 19:24:12 GMT https://community.qlik.com/t5/QlikView/Help-with-Expression/m-p/1305550#M406419 aarohipatel 2017-03-29T19:24:12Z Re: Help with Expression https://community.qlik.com/t5/QlikView/Help-with-Expression/m-p/1305551#M406420 <HTML><HEAD></HEAD><BODY><P>I think you need a nested aggregation</P><P><A href="https://community.qlik.com/qlik-blogpost/4418">Pitfalls of the Aggr function</A></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>Count(ID) </EM></SPAN></P><P><EM style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">/ </EM></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>Sum(&nbsp;&nbsp; aggr(Count (ID), field1, field2, ....)&nbsp;&nbsp; )</EM></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Maybe you can post your .qvw<BR /></SPAN></P></BODY></HTML> Wed, 29 Mar 2017 19:30:00 GMT https://community.qlik.com/t5/QlikView/Help-with-Expression/m-p/1305551#M406420 maxgro 2017-03-29T19:30:00Z Re: Help with Expression https://community.qlik.com/t5/QlikView/Help-with-Expression/m-p/1305552#M406421 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><STRONG>Count(ID)/Count(TOTAL ID)</STRONG></P></BODY></HTML> Wed, 29 Mar 2017 19:30:17 GMT https://community.qlik.com/t5/QlikView/Help-with-Expression/m-p/1305552#M406421 sunny_talwar 2017-03-29T19:30:17Z