topic Pivot Table expression in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-expression/m-p/273279#M1206079 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />try expression</P><P style="font-weight: bold">Sum({&lt;OverviewInventoryTransHistory.TRANSACTION_CODE={'SCP'}&gt;} COST)</P><P></P><P>Alex</P></BODY></HTML> Fri, 27 Aug 2010 08:32:13 GMT 2010-08-27T08:32:13Z Pivot Table expression https://community.qlik.com/t5/QlikView/Pivot-Table-expression/m-p/273278#M1206078 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">What I am looking for is an expression which calculates the SUM COST only for a field where the TRANSACTION_CODE = 'SCP'</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">Here is what I have so far but it is not displaying what I am looking for</P><P style="margin: 0cm 0cm 0pt;"></P><P>Sum ({$&lt;COST = [$(OverviewInventoryTransHistory.TRANSACTION_CODE = 'SCP'))}&gt;}</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">I am new to Qlikview and any help would be much appreciated</P></BODY></HTML> Fri, 27 Aug 2010 08:10:19 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-expression/m-p/273278#M1206078 2010-08-27T08:10:19Z Pivot Table expression https://community.qlik.com/t5/QlikView/Pivot-Table-expression/m-p/273279#M1206079 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />try expression</P><P style="font-weight: bold">Sum({&lt;OverviewInventoryTransHistory.TRANSACTION_CODE={'SCP'}&gt;} COST)</P><P></P><P>Alex</P></BODY></HTML> Fri, 27 Aug 2010 08:32:13 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-expression/m-p/273279#M1206079 2010-08-27T08:32:13Z