topic AGGR Function in QlikView https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/103251#M16319 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P></P><P>I want to create pivot table ,but&nbsp; value after <SPAN style="font-size: 13.3333px;">create pivot table&nbsp; found that double data.</SPAN></P><P></P><P>This is my code</P><P>=aggr(sum((Fabric_QTY)*(ITEM_CONTAIN)/100),YARN_ITEM)</P><P></P><P><IMG alt="จับภาพ.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209811_จับภาพ.PNG" style="height: 376px; width: 620px;" /></P></BODY></HTML> Fri, 03 Aug 2018 10:52:05 GMT penpayom 2018-08-03T10:52:05Z AGGR Function https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/103251#M16319 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P></P><P>I want to create pivot table ,but&nbsp; value after <SPAN style="font-size: 13.3333px;">create pivot table&nbsp; found that double data.</SPAN></P><P></P><P>This is my code</P><P>=aggr(sum((Fabric_QTY)*(ITEM_CONTAIN)/100),YARN_ITEM)</P><P></P><P><IMG alt="จับภาพ.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209811_จับภาพ.PNG" style="height: 376px; width: 620px;" /></P></BODY></HTML> Fri, 03 Aug 2018 10:52:05 GMT https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/103251#M16319 penpayom 2018-08-03T10:52:05Z Re: AGGR Function https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/103252#M16320 <HTML><HEAD></HEAD><BODY><P>Could you share your sample app?</P></BODY></HTML> Fri, 03 Aug 2018 10:56:15 GMT https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/103252#M16320 tresB 2018-08-03T10:56:15Z Re: AGGR Function https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/103253#M16321 <HTML><HEAD></HEAD><BODY><P>Is this the same expression you have used in both the charts?</P></BODY></HTML> Fri, 03 Aug 2018 11:16:58 GMT https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/103253#M16321 sunny_talwar 2018-08-03T11:16:58Z