https://community.qlik.com/t5/Talend-Studio/tAggregateSortedRow-Problem/m-p/2324681#M94354 <P>Hello i have a problem with&nbsp;tAggregateSortedRow &nbsp;component , i have as input the list of employees and i have the number of his working days on each month i have used the tAggregateSortedRow &nbsp;to calculate the number of days worked in each month and after that i group them in each month so as a result i have get a problem that group by doesn't work perfect&nbsp;<BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFTM.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136201iD55990F7B940AA4A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFTM.png" alt="0683p000009MFTM.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFeC.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134733i3753B76FCD17197E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFeC.png" alt="0683p000009MFeC.png" /></span></P> Sun, 21 Aug 2016 00:15:33 GMT Anonymous 2016-08-21T00:15:33Z https://community.qlik.com/t5/Talend-Studio/tAggregateSortedRow-Problem/m-p/2324681#M94354 <P>Hello i have a problem with&nbsp;tAggregateSortedRow &nbsp;component , i have as input the list of employees and i have the number of his working days on each month i have used the tAggregateSortedRow &nbsp;to calculate the number of days worked in each month and after that i group them in each month so as a result i have get a problem that group by doesn't work perfect&nbsp;<BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFTM.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136201iD55990F7B940AA4A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFTM.png" alt="0683p000009MFTM.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFeC.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134733i3753B76FCD17197E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFeC.png" alt="0683p000009MFeC.png" /></span></P> Sun, 21 Aug 2016 00:15:33 GMT https://community.qlik.com/t5/Talend-Studio/tAggregateSortedRow-Problem/m-p/2324681#M94354 Anonymous 2016-08-21T00:15:33Z https://community.qlik.com/t5/Talend-Studio/tAggregateSortedRow-Problem/m-p/2324682#M94355 You need to sort the data first. Try using the tAggregateRow component instead Sun, 21 Aug 2016 02:42:16 GMT https://community.qlik.com/t5/Talend-Studio/tAggregateSortedRow-Problem/m-p/2324682#M94355 Anonymous 2016-08-21T02:42:16Z https://community.qlik.com/t5/Talend-Studio/tAggregateSortedRow-Problem/m-p/2324683#M94356 Yes it works i have to sort by name and month and also to group by month and name thank's Sun, 21 Aug 2016 10:01:33 GMT https://community.qlik.com/t5/Talend-Studio/tAggregateSortedRow-Problem/m-p/2324683#M94356 Anonymous 2016-08-21T10:01:33Z