topic pivot table sum = 0 in QlikView https://community.qlik.com/t5/QlikView/pivot-table-sum-0/m-p/759836#M270351 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i have 3 dimensions in my pivot table </P><P></P><P>textvalue, salesid, itemid</P><P></P><P>my expression is</P><P></P><P>aggr(FirstSortedValue(COSTPRICE,-MODIFIEDDATETIME_INVENTTABLEMODUL) * SUM({&lt;TCMSALESORDERYear={'$(vMaxYearOrder)'},TCMSALESORDERMonth={'$(vMaxMonthOrder)'},TCMSALESORDERDay={'&lt;=$(vMaxDayOrder)'},TCMSALESORDERDATE=,TCMSALESORDERMonthYear=&gt;}QTYORDERED),TEXTVALUE, SALESID, ITEMID)</P><P></P><P></P><P>my problem is the aggr function i dont get the sum of the column ??</P><P> can anybody help me ? </P></BODY></HTML> Fri, 09 Jan 2015 09:00:08 GMT 2015-01-09T09:00:08Z pivot table sum = 0 https://community.qlik.com/t5/QlikView/pivot-table-sum-0/m-p/759836#M270351 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i have 3 dimensions in my pivot table </P><P></P><P>textvalue, salesid, itemid</P><P></P><P>my expression is</P><P></P><P>aggr(FirstSortedValue(COSTPRICE,-MODIFIEDDATETIME_INVENTTABLEMODUL) * SUM({&lt;TCMSALESORDERYear={'$(vMaxYearOrder)'},TCMSALESORDERMonth={'$(vMaxMonthOrder)'},TCMSALESORDERDay={'&lt;=$(vMaxDayOrder)'},TCMSALESORDERDATE=,TCMSALESORDERMonthYear=&gt;}QTYORDERED),TEXTVALUE, SALESID, ITEMID)</P><P></P><P></P><P>my problem is the aggr function i dont get the sum of the column ??</P><P> can anybody help me ? </P></BODY></HTML> Fri, 09 Jan 2015 09:00:08 GMT https://community.qlik.com/t5/QlikView/pivot-table-sum-0/m-p/759836#M270351 2015-01-09T09:00:08Z Re: pivot table sum = 0 https://community.qlik.com/t5/QlikView/pivot-table-sum-0/m-p/759837#M270352 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Try giving an aggregate function like sum() or count()<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum(<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">aggr(FirstSortedValue(COSTPRICE,-MODIFIEDDATETIME_INVENTTABLEMODUL) * SUM({&lt;TCMSALESORDERYear={'$(vMaxYearOrder)'},TCMSALESORDERMonth={'$(vMaxMonthOrder)'},TCMSALESORDERDay={'&lt;=$(vMaxDayOrder)'},TCMSALESORDERDATE=,TCMSALESORDERMonthYear=&gt;}QTYORDERED),TEXTVALUE, SALESID, ITEMID))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Regards,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">jagan.<BR /></SPAN></P></BODY></HTML> Fri, 09 Jan 2015 09:10:07 GMT https://community.qlik.com/t5/QlikView/pivot-table-sum-0/m-p/759837#M270352 jagan 2015-01-09T09:10:07Z