topic average of column average in QlikView https://community.qlik.com/t5/QlikView/average-of-column-average/m-p/1144934#M908395 <HTML><HEAD></HEAD><BODY><P>Hi I want to calculate average of the column average. For example, I have q2 and q3. I want to calculate avg(avg(q2),avg(q3)). This formula doesn't work in Qlikview. You may say why not use (Avg(q2)+Avg(q3))/2. Well, I can't because I don't want to count missing value for avg(q2) and avg(q3). RangeAvg doesn't work either.</P><P></P><P>Any help will be appreciated!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z average of column average https://community.qlik.com/t5/QlikView/average-of-column-average/m-p/1144934#M908395 <HTML><HEAD></HEAD><BODY><P>Hi I want to calculate average of the column average. For example, I have q2 and q3. I want to calculate avg(avg(q2),avg(q3)). This formula doesn't work in Qlikview. You may say why not use (Avg(q2)+Avg(q3))/2. Well, I can't because I don't want to count missing value for avg(q2) and avg(q3). RangeAvg doesn't work either.</P><P></P><P>Any help will be appreciated!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/average-of-column-average/m-p/1144934#M908395 2020-11-25T16:16:04Z Re: average of column average https://community.qlik.com/t5/QlikView/average-of-column-average/m-p/1144935#M908396 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you share me some sample data or qvw</P></BODY></HTML> Fri, 17 Jun 2016 20:15:25 GMT https://community.qlik.com/t5/QlikView/average-of-column-average/m-p/1144935#M908396 krishnacbe 2016-06-17T20:15:25Z Re: average of column average https://community.qlik.com/t5/QlikView/average-of-column-average/m-p/1144936#M908397 <HTML><HEAD></HEAD><BODY><P>I already figured this out. RangeAvg is the answer. </P><P>Thanks.</P></BODY></HTML> Fri, 17 Jun 2016 20:22:16 GMT https://community.qlik.com/t5/QlikView/average-of-column-average/m-p/1144936#M908397 2016-06-17T20:22:16Z Re: average of column average https://community.qlik.com/t5/QlikView/average-of-column-average/m-p/1144937#M908398 <HTML><HEAD></HEAD><BODY><P>Great, then please close this thread as 'Assumed answered'</P></BODY></HTML> Fri, 17 Jun 2016 20:42:18 GMT https://community.qlik.com/t5/QlikView/average-of-column-average/m-p/1144937#M908398 swuehl 2016-06-17T20:42:18Z