topic avg in QlikView https://community.qlik.com/t5/QlikView/avg/m-p/1452630#M801015 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to get average of 1st and 2nd expression in the app.</P><P></P><P>avg(exp1/exp2)</P><P></P><P>Please help.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT surajap123 2020-11-25T16:16:04Z avg https://community.qlik.com/t5/QlikView/avg/m-p/1452630#M801015 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to get average of 1st and 2nd expression in the app.</P><P></P><P>avg(exp1/exp2)</P><P></P><P>Please help.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/avg/m-p/1452630#M801015 surajap123 2020-11-25T16:16:04Z Re: avg https://community.qlik.com/t5/QlikView/avg/m-p/1452631#M801016 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>Avg(Aggr((count({&lt;Product = {"=sum(Sales)&gt;0"}&gt;}DISTINCT Product) / count(DISTINCT Product)), Category, Product))</STRONG></P></BODY></HTML> Fri, 24 Nov 2017 15:54:00 GMT https://community.qlik.com/t5/QlikView/avg/m-p/1452631#M801016 Anil_Babu_Samineni 2017-11-24T15:54:00Z Re: avg https://community.qlik.com/t5/QlikView/avg/m-p/1452632#M801017 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>may be try this,</P><P></P><P>=Num(count({&lt;Product = {"=sum(Sales)&gt;0"}&gt;}DISTINCT Product)</P><P>/</P><P>count(DISTINCT Product),'#,##0%')</P></BODY></HTML> Fri, 24 Nov 2017 15:56:00 GMT https://community.qlik.com/t5/QlikView/avg/m-p/1452632#M801017 mdmukramali 2017-11-24T15:56:00Z Re: avg https://community.qlik.com/t5/QlikView/avg/m-p/1452633#M801018 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Another simplest way like below</P><P><STRONG>=Column(1)/Column(2)</STRONG></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/184517_Capture.JPG" style="height: 98px; width: 620px;" /></P></BODY></HTML> Fri, 24 Nov 2017 16:25:01 GMT https://community.qlik.com/t5/QlikView/avg/m-p/1452633#M801018 devarasu07 2017-11-24T16:25:01Z