topic Re: PIVOT (Calculation) in QlikView https://community.qlik.com/t5/QlikView/PIVOT-Calculation/m-p/511892#M549536 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Sat, 21 Dec 2013 12:16:31 GMT Gysbert_Wassenaar 2013-12-21T12:16:31Z PIVOT (Calculation) https://community.qlik.com/t5/QlikView/PIVOT-Calculation/m-p/511890#M549534 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am building a PIVOT table. I have been facing issue in getting the Correct AVG(Average) values for the table.</P><P></P><P>I have attached an Excel to showcase the issue.</P><P></P><P>Thanks,</P><P>H</P></BODY></HTML> Fri, 20 Dec 2013 00:37:12 GMT https://community.qlik.com/t5/QlikView/PIVOT-Calculation/m-p/511890#M549534 hkg_qlik 2013-12-20T00:37:12Z Re: PIVOT (Calculation) https://community.qlik.com/t5/QlikView/PIVOT-Calculation/m-p/511891#M549535 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Based on the excel, it looks like you need average days aggregated over cycle and code. If this is the case, this expression may work:&nbsp; aggr(avg(DAYS),Cycle, Code)</P><P></P><P>If you upload a qvw this would be easier to test.</P><P></P><P>Hope that helps.</P><P></P><P>Matt</P></BODY></HTML> Sat, 21 Dec 2013 01:07:29 GMT https://community.qlik.com/t5/QlikView/PIVOT-Calculation/m-p/511891#M549535 2013-12-21T01:07:29Z Re: PIVOT (Calculation) https://community.qlik.com/t5/QlikView/PIVOT-Calculation/m-p/511892#M549536 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Sat, 21 Dec 2013 12:16:31 GMT https://community.qlik.com/t5/QlikView/PIVOT-Calculation/m-p/511892#M549536 Gysbert_Wassenaar 2013-12-21T12:16:31Z