https://community.qlik.com/t5/App-Development/Aggregate/m-p/1891150#M73436 <P>it shows zero or dash.</P> <P>Thanks</P> <P>&nbsp;</P> Wed, 09 Feb 2022 17:17:45 GMT niranjana 2022-02-09T17:17:45Z https://community.qlik.com/t5/App-Development/Aggregate/m-p/1888175#M73187 <P>Hi,</P> <P>I need help in framing an aggregate function within set analysis within Sum function:</P> <P>aggr(Sum({&lt;Year={"$(=Year(Max(Date)))"},Month={"&lt;=$(=Num(Month(Max(Date))))"}&gt;}New_Sales),Product,Pack,Distributor,ATC4,[Ret/Hosp]).&nbsp;</P> <P>But it is not working. I need to sum the "New_Sales" within the set analysis and aggregate that sum with dimensions Product, Pack,Distributor, ATC4, Ret/Hosp. This expression is used in a straight table.&nbsp;</P> <P>Only aggregate part is throwing error.</P> <P>Dimension is Product and measure is New_Sales as shown above</P> <P>Any help is appreciated.</P> Wed, 02 Feb 2022 14:05:14 GMT https://community.qlik.com/t5/App-Development/Aggregate/m-p/1888175#M73187 niranjana 2022-02-02T14:05:14Z https://community.qlik.com/t5/App-Development/Aggregate/m-p/1890945#M73401 <P>which error does it throw?</P> Wed, 09 Feb 2022 12:32:19 GMT https://community.qlik.com/t5/App-Development/Aggregate/m-p/1890945#M73401 chris_djih 2022-02-09T12:32:19Z https://community.qlik.com/t5/App-Development/Aggregate/m-p/1891150#M73436 <P>it shows zero or dash.</P> <P>Thanks</P> <P>&nbsp;</P> Wed, 09 Feb 2022 17:17:45 GMT https://community.qlik.com/t5/App-Development/Aggregate/m-p/1891150#M73436 niranjana 2022-02-09T17:17:45Z