https://community.qlik.com/t5/App-Development/Aggregate-per-Material-and-Display-by-Month/m-p/2064381#M87311 <P>Dear Gurús,&nbsp;</P> <P>I'm trying to apply a simple calculation (actually it's much more complex but I'm simplifying it just as an example) where I need to see the Billing Amount aggregated by Material. Something like:&nbsp;</P> <P>Sum(Aggr(Num(Sum( [Billing Amount in LC])), Material))</P> <P>If I see the result in a Table and select one single month (like Fabruary 2023), the result changes as if I see in the table all the months of 2023 (the correct value appears when I select one single month). I attach two screenshots:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jorditorras_0-1682437090659.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105794iD76FE0771FB2941C/image-size/medium?v=v2&amp;px=400" role="button" title="jorditorras_0-1682437090659.png" alt="jorditorras_0-1682437090659.png" /></span></P> <P>And if I unslect fabruary, his result changes:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jorditorras_1-1682437140164.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105795i1784C975A2049D33/image-size/medium?v=v2&amp;px=400" role="button" title="jorditorras_1-1682437140164.png" alt="jorditorras_1-1682437140164.png" /></span></P> <P>&nbsp;</P> <P>Any idea about why this behaviour is happening??</P> <P>Thanks in advance.&nbsp;</P> <P>Regards,&nbsp;</P> <P>Jordi&nbsp;</P> Fri, 15 Nov 2024 21:52:04 GMT jorditorras 2024-11-15T21:52:04Z https://community.qlik.com/t5/App-Development/Aggregate-per-Material-and-Display-by-Month/m-p/2064381#M87311 <P>Dear Gurús,&nbsp;</P> <P>I'm trying to apply a simple calculation (actually it's much more complex but I'm simplifying it just as an example) where I need to see the Billing Amount aggregated by Material. Something like:&nbsp;</P> <P>Sum(Aggr(Num(Sum( [Billing Amount in LC])), Material))</P> <P>If I see the result in a Table and select one single month (like Fabruary 2023), the result changes as if I see in the table all the months of 2023 (the correct value appears when I select one single month). I attach two screenshots:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jorditorras_0-1682437090659.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105794iD76FE0771FB2941C/image-size/medium?v=v2&amp;px=400" role="button" title="jorditorras_0-1682437090659.png" alt="jorditorras_0-1682437090659.png" /></span></P> <P>And if I unslect fabruary, his result changes:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jorditorras_1-1682437140164.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105795i1784C975A2049D33/image-size/medium?v=v2&amp;px=400" role="button" title="jorditorras_1-1682437140164.png" alt="jorditorras_1-1682437140164.png" /></span></P> <P>&nbsp;</P> <P>Any idea about why this behaviour is happening??</P> <P>Thanks in advance.&nbsp;</P> <P>Regards,&nbsp;</P> <P>Jordi&nbsp;</P> Fri, 15 Nov 2024 21:52:04 GMT https://community.qlik.com/t5/App-Development/Aggregate-per-Material-and-Display-by-Month/m-p/2064381#M87311 jorditorras 2024-11-15T21:52:04Z https://community.qlik.com/t5/App-Development/Aggregate-per-Material-and-Display-by-Month/m-p/2064414#M87313 <P>Sum(Aggr(Num(Sum( [Billing Amount in LC])), <FONT color="#FF0000"><STRONG>Month_ES</STRONG>,</FONT> Material))</P> Tue, 25 Apr 2023 16:58:15 GMT https://community.qlik.com/t5/App-Development/Aggregate-per-Material-and-Display-by-Month/m-p/2064414#M87313 BrunPierre 2023-04-25T16:58:15Z