Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tAggregateSortedRow Problem

Hello i have a problem with tAggregateSortedRow  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  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 
0683p000009MFTM.png0683p000009MFeC.png

Labels (2)
2 Replies
Anonymous
Not applicable
Author

You need to sort the data first. Try using the tAggregateRow component instead
Anonymous
Not applicable
Author

Yes it works i have to sort by name and month and also to group by month and name thank's